My Portfolio

FA-SLA-GL Linking in R12:  select * from apps.fnd_application_vl where application_name like '%Asset%'         1> Fixed Asset Tables  :                select * from  apps.FA_Transaction_Headers where BOOK_TYPE_CODE= 'OPS CORP' and  asset_id=110279--event_id=4229742             select * from apps.FA_ADDITIONS_B where ASSET_ID=110279             select * from apps.FA_BOOKS where asset_id=110279             select * from apps.FA_DEPRN_SUMMARY where ASSET_ID=110279             select * from apps.FA_DEPRN_DETAIL where ASSET_ID=110279              select * from apps.FA_DEPRN_PERIODS where BOOK_TYPE_CODE= 'OPS CORP' and FISCAL_YEAR=...

1.) AP-NOPROJ-ENTRIES-JAN TO MAR SELECT   d.ACCOUNTING_DATE, i.invoice_num, i.invoice_date, i.invoice_amount, d.amount,          d.accounting_date, g.segment4, g.segment6, d.project_id , g.concatenated_segments, d.invoice_distribution_id,          i.creation_date, d.status, d.posted_status_disp     FROM ap_invoices_v i,          ap_invoice_lines_all l,          ap_invoice_distributions_v d,          gl_code_combinations_kfv g    WHERE i.invoice_id = l.invoice_id      AND i.invoice_id = d.invoice_id      AND l.line_number = d.invoice_line_number      AND d.dist_code_combination_id = g.code_combination_id      AND d.project_id IS NULL      AND i.vendor_id != 313296      AND g.segment6 != '0000'      AND g.segment4 LIKE '13%'   ...

Complete relation Query for SLA(Sub Ledger Accounting _XLA),AP(Account Payable) and GL(General Ledger) Links in oracle apps r12  Or  Link Between AP(Account Payable),GL(General Ledger) and SLA(Sub Ledger Accounting _XLA) SELECT DISTINCT GJH.PERIOD_NAME, TRUNC (GJH.CREATION_DATE) GL_DATE,                 GJH.JE_SOURCE, GJH.JE_CATEGORY, GJH.CURRENCY_CODE,                 GJL.DESCRIPTION, GJL.REFERENCE_5, GJL.REFERENCE_10,                 GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, GJL.EFFECTIVE_DATE,                 GJL.REFERENCE_1, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3,                 GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7,                 AERLA.JUSTIFICATION, AERLA.PROJECT_NUMBER,               ...

AP: Find AP Invoice Summary Data: SELECT ai.invoice_id,   SUBSTR(ai.invoice_num,1,25) invoice_num,   SUBSTR(aps.vendor_name,1,25) vendor_name,   ai.invoice_date,   ai.invoice_amount,   ai.base_amount,   SUBSTR(ai.invoice_type_lookup_code,1,15) invoice_type_lookup_code,   SUBSTR(ai.invoice_currency_code,1,3) invoice_currency_code,   SUBSTR(ai.payment_currency_code,1,3) payment_currency_code,   ai.legal_entity_id,   ai.org_id FROM AP_INVOICES_ALL ai,   AP_SUPPLIERS aps,   AP_SUPPLIER_SITES_ALL avs WHERE ai.invoice_id   = '&Invoice_ID' AND ai.vendor_id      = aps.vendor_id(+) and AI.VENDOR_SITE_ID = AVS.VENDOR_SITE_ID(+) ORDER BY ai.invoice_id ASC; Find AP Invoice Lines Summary: SELECT LINE_NUMBER,   LINE_TYPE_LOOKUP_CODE,   LINE_SOURCE,   ACCOUNTING_DATE,   PERIOD_NAME,   AMOUNT,   SUMMARY_TAX_LINE_ID,   DEFERRED_ACCTG_FLAG,   ORG_ID FROM AP_INVOICE_LINES_ALL where I...

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 SELECT      aia.INVOICE_ID "Invoice Id" ,      aia.INVOICE_NUM "Invoice Number" ,      aia.INVOICE_DATE "Invoice Date" ,      aia.INVOICE_AMOUNT "Amount" ,      xal.ENTERED_DR "Entered DR in SLA" ,      xal.ENTERED_CR "Entered CR in SLA" ,      xal.ACCOUNTED_DR "Accounted DR in SLA" ,      xal.ACCOUNTED_CR "Accounted CR in SLA" ,      gjl.ENTERED_DR "Entered DR in GL" ,      gjl.ACCOUNTED_DR "Accounted DR in GL" ,      xal.ACCOUNTING_CLASS_CODE "Accounting Class" ,      gcc.SEGMENT1|| '.' ||gcc.SEGMENT2|| '.'   ...