eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on XLA_AE_LINES

Line 745: Xla_Ae_Lines Ael

741: FROM Ap_Invoices_All Aia,
742: Xla_Transaction_Entities Ent,
743: Ja_Cn_Code_Combination_v Jcc,
744: Xla_Ae_Headers Aeh,
745: Xla_Ae_Lines Ael
746: WHERE Ent.Application_Id = 200
747: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
748: AND Ent.Entity_Code = 'AP_INVOICES'
749: AND Ent.Entity_Id = Aeh.Entity_Id

Line 887: FROM Xla_Ae_Lines Ael, Xla_Ae_Headers Aeh

883: --Cursor for fetching invoice amount or payment amount at SLA level
884: CURSOR amount_cur IS
885: SELECT SUM(-1 * NVL(Ael.Accounted_Dr, 0) + NVL(Ael.Accounted_Cr, 0)) Functional_Amount,
886: SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Entered_Amount
887: FROM Xla_Ae_Lines Ael, Xla_Ae_Headers Aeh
888: WHERE Ael.Ae_Header_Id = Aeh.Ae_Header_Id
889: AND Ael.Accounting_Class_Code = 'LIABILITY'
890: AND ((pn_invoice_id IS NULL AND Aeh.Ae_Header_Id = pn_ae_header_id) --parameter: pn_ae_header_id
891: OR (pn_invoice_id IS NOT NULL AND

Line 1051: FROM Xla_Ae_Lines Ael,

1047: --Cursor for fetching invoice amount or payment amount at SLA level
1048: CURSOR amount_cur IS
1049: SELECT SUM(NVL(Ael.Accounted_Dr, 0) + -1 * NVL(Ael.Accounted_Cr, 0)) Functional_Amount,
1050: SUM(NVL(Ael.Entered_Dr, 0) + -1 * NVL(Ael.Entered_Cr, 0)) Entered_Amount
1051: FROM Xla_Ae_Lines Ael,
1052: Xla_Ae_Headers Aeh,
1053: Ja_Cn_Code_Combination_v Jcc
1054: WHERE Ael.Ae_Header_Id = Aeh.Ae_Header_Id
1055: AND Ael.Accounting_Class_Code <> 'LIABILITY'

Line 1664: Xla_Ae_Lines Ael

1660: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Inv_Amount
1661: FROM Ap_Invoices_All Aia,
1662: Xla_Transaction_Entities Ent,
1663: Xla_Ae_Headers Aeh,
1664: Xla_Ae_Lines Ael
1665: WHERE Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1666: --SLA condition
1667: AND Ent.Application_Id = 200
1668: AND Aia.Invoice_Id = Ent.Source_Id_Int_1

Line 1675: FROM Xla_Ae_Lines Ael1

1671: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1672: AND Ael.Accounting_Class_Code = 'LIABILITY'
1673: AND (Aia.Invoice_Type_Lookup_Code = 'PREPAYMENT' OR NOT EXISTS
1674: (SELECT Ael1.Ae_HEADER_ID --filter accounting line for prepayment application
1675: FROM Xla_Ae_Lines Ael1
1676: WHERE Aeh.Ae_Header_Id = Ael1.Ae_Header_Id
1677: AND Ael1.Accounting_Class_Code = 'PREPAID_EXPENSE'))
1678: AND Aeh.Ae_Header_Id = Ael.Ae_Header_Id
1679: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines

Line 1701: Xla_Ae_Lines Ael,

1697: Ap_Checks_All Ach,
1698: Ap_Invoice_Payments_All Aip,
1699: Xla_Transaction_Entities Ent,
1700: Xla_Ae_Headers Aeh,
1701: Xla_Ae_Lines Ael,
1702: Gl_Je_Headers Jeh,
1703: Gl_Import_References Gir
1704: WHERE Aia.Invoice_Id = Aip.Invoice_Id
1705: AND Ach.Check_Id = Aip.Check_Id

Line 1742: Xla_Ae_Lines Ael,

1738: (SELECT Ach.Check_Id
1739: FROM Ap_Checks_All Ach,
1740: Xla_Transaction_Entities Ent,
1741: Xla_Ae_Headers Aeh,
1742: Xla_Ae_Lines Ael,
1743: Gl_Je_Headers Jeh,
1744: Gl_Import_References Gir
1745: WHERE Ach.Check_Id = Aip.Check_Id
1746: AND Aip.Accounting_Date <=

Line 1783: Xla_Ae_Lines Ael,

1779: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Paid_Amount
1780: FROM Ap_Invoices_All Aia,
1781: Xla_Transaction_Entities Ent,
1782: Xla_Ae_Headers Aeh,
1783: Xla_Ae_Lines Ael,
1784: Gl_Je_Headers Jeh,
1785: Gl_Import_References Gir
1786: WHERE Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1787: AND Aia.Invoice_Type_Lookup_Code <> 'PREPAYMENT'

Line 1896: Xla_Ae_Lines Ael,

1892: SELECT SUM(NVL(Ael.Entered_Dr, 0) + -1 * NVL(Ael.Entered_Cr, 0)) Prepaid_Amount
1893: FROM Ap_Invoices_All Aia,
1894: Xla_Transaction_Entities Ent,
1895: Xla_Ae_Headers Aeh,
1896: Xla_Ae_Lines Ael,
1897: Ja_Cn_Code_Combination_v Jcc
1898: WHERE Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1899: AND Aia.Invoice_Type_Lookup_Code = 'PREPAYMENT'
1900: --SLA condition

Line 1926: Xla_Ae_Lines Ael,

1922: --collecting applied amount
1923: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Applied_Amount
1924: FROM Ap_Prepay_History_All Aph,
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Ja_Cn_Code_Combination_v Jcc,
1928: Gl_Je_Headers Jeh,
1929: Gl_Import_References Gir
1930: WHERE Aph.Prepay_Invoice_Id = pn_invoice_id --parameter: pn_invoice_id

Line 2036: Xla_Ae_Lines Ael,

2032: CURSOR account_number_cur(lv_accouting_class_code VARCHAR2) IS
2033: SELECT DISTINCT Account_Number
2034: FROM (SELECT Jab.Account_Segment Account_Number
2035: FROM Xla_Ae_Headers Aeh,
2036: Xla_Ae_Lines Ael,
2037: Ja_Cn_Code_Combination_v Jcc,
2038: Ja_Cn_Account_Balances Jab
2039: WHERE Jab.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2040: AND Jab.Legal_Entity_Id = pn_legal_entity_id --parameter: pn_legal_entity_id

Line 2249: Xla_Ae_Lines Ael,

2245: Gl_Import_References Gir,
2246: Ja_Cn_Code_Combination_v Jcc,
2247: Gl_Ledgers Gl,
2248: Gl_Periods Gp,
2249: Xla_Ae_Lines Ael,
2250: Xla_Ae_Headers Aeh,
2251: Ap_Suppliers Sup
2252: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
2253: AND Gir.Je_Header_Id = Jeh.Je_Header_Id

Line 2658: Xla_Ae_Lines Ael,

2654: Gl_Import_References Gir,
2655: Ja_Cn_Code_Combination_v Jcc,
2656: Gl_Ledgers Gl,
2657: Gl_Periods Gp,
2658: Xla_Ae_Lines Ael,
2659: Xla_Ae_Headers Aeh,
2660: Ap_Suppliers Sup,
2661: Fnd_Currencies_Vl Fcv
2662: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 2812: Xla_Ae_Lines Ael,

2808: Po_Headers_All Pha,
2809: Fnd_Currencies_Vl Fcv,
2810: Xla_Transaction_Entities Ent,
2811: Xla_Ae_Headers Aeh,
2812: Xla_Ae_Lines Ael,
2813: Gl_Je_Headers Jeh,
2814: Gl_Import_References Gir
2815: WHERE Aia.Invoice_Id = ln_invoice_id --variable: ln_invoice_id
2816: --PO, project, currency condition

Line 2892: Xla_Ae_Lines Ael,

2888: Ap_Checks_All Ach,
2889: Ap_Invoice_Payments_All Aip,
2890: Xla_Transaction_Entities Ent,
2891: Xla_Ae_Headers Aeh,
2892: Xla_Ae_Lines Ael,
2893: Gl_Je_Headers Jeh,
2894: Gl_Import_References Gir,
2895: Pa_Projects_All Pap,
2896: Po_Headers_All Pha,

Line 2912: FROM Xla_Ae_Lines Ael1

2908: AND (Aia.Invoice_Type_Lookup_Code = 'PREPAYMENT' --collecting payment of prepayment invoice
2909: OR NOT EXISTS
2910: ( --to filter prepayment application
2911: SELECT Ael1.Ae_Header_Id
2912: FROM Xla_Ae_Lines Ael1
2913: WHERE Ael1.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2914: AND Ael1.Accounting_Class_Code = 'PREPAID_EXPENSE'))
2915: --Judge whether ae_header_id is from payment or not,
2916: --if Yes, indicating that invoice id was derived from payment journal

Line 2978: Xla_Ae_Lines Ael,

2974: '' Remittance_Bill_Number
2975: FROM Ap_Invoices_All Aia,
2976: Xla_Transaction_Entities Ent,
2977: Xla_Ae_Headers Aeh,
2978: Xla_Ae_Lines Ael,
2979: Gl_Je_Headers Jeh,
2980: Gl_Import_References Gir,
2981: Pa_Projects_All Pap,
2982: Po_Headers_All Pha,

Line 2995: FROM Xla_Ae_Lines Ael1

2991: AND (Aia.Invoice_Type_Lookup_Code = 'PREPAYMENT' --collecting prepayment inforamtion
2992: OR NOT EXISTS
2993: ( --collecting invoice which is applied with prepayment
2994: SELECT Ael1.Ae_Header_Id
2995: FROM Xla_Ae_Lines Ael1
2996: WHERE Ael1.Ae_Header_Id = Aeh.Ae_Header_Id
2997: AND Ael1.Accounting_Class_Code = 'PREPAID_EXPENSE'))
2998: --GL condition
2999: AND Gir.Gl_Sl_Link_Id = Ael.Gl_Sl_Link_Id

Line 3022: Xla_Ae_Lines Ael

3018: CURSOR prepaid_account_num_cur(ln_ae_header_id NUMBER) IS
3019: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num
3020: FROM Ja_Cn_Code_Combination_v Jcc,
3021: Xla_Ae_Headers Aeh,
3022: Xla_Ae_Lines Ael
3023: WHERE Ael.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
3024: AND Ael.Ae_Header_Id = Aeh.Ae_Header_Id
3025: AND Aeh.Ledger_Id = Jcc.Ledger_id
3026: AND ((Aeh.Event_Type_Code = 'PREPAYMENT APPLIED' AND