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_HEADERS

Line 744: Xla_Ae_Headers Aeh,

740: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num
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'

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 895: Xla_Ae_Headers Aeh1

891: OR (pn_invoice_id IS NOT NULL AND
892: Aeh.Ae_Header_Id =
893: (DECODE((SELECT COUNT(*)
894: FROM Xla_Transaction_Entities Ent1,
895: Xla_Ae_Headers Aeh1
896: WHERE Ent1.Application_Id = 200
897: AND Ent1.Entity_Code = 'AP_INVOICES'
898: AND Ent1.Entity_Id = Aeh1.Entity_Id
899: AND Aeh1.Ae_Header_Id = pn_ae_header_id --parameter: pn_ae_header_id

Line 905: Xla_Ae_Headers Aeh1

901: 0,
902: (SELECT MIN(Aeh1.Ae_Header_Id)
903: FROM Ap_Invoices_All Aia1,
904: Xla_Transaction_Entities Ent1,
905: Xla_Ae_Headers Aeh1
906: WHERE Ent1.Application_Id = 200
907: AND Aia1.Invoice_Id = Ent1.Source_Id_Int_1
908: AND Ent1.Entity_Code = 'AP_INVOICES'
909: AND Ent1.Entity_Id = Aeh1.Entity_Id

Line 1052: Xla_Ae_Headers Aeh,

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'
1056: AND Aeh.Ae_Header_Id = pn_ae_header_id --parameter: pn_ae_header_id

Line 1663: Xla_Ae_Headers Aeh,

1659: CURSOR inv_amount_cur IS
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

Line 1700: Xla_Ae_Headers Aeh,

1696: FROM Ap_Invoices_All Aia,
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

Line 1741: Xla_Ae_Headers Aeh,

1737: AND EXISTS
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

Line 1782: Xla_Ae_Headers Aeh,

1778: --collecting prepaid amount
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

Line 1895: Xla_Ae_Headers Aeh,

1891: CURSOR prepaid_amount_cur IS
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'

Line 1925: Xla_Ae_Headers Aeh,

1921: CURSOR applied_amount_cur IS
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

Line 2035: FROM Xla_Ae_Headers Aeh,

2031: --getting account number
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

Line 2250: Xla_Ae_Headers Aeh,

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
2254: AND Gir.Je_Line_Num = Jel.Je_Line_Num

Line 2476: from Xla_Ae_Headers

2472: where invoice_id = p_invioce_id;
2473:
2474: select EVENT_TYPE_CODE
2475: into l_enent_type_code
2476: from Xla_Ae_Headers
2477: where Ae_Header_Id = p_ae_header_id;
2478:
2479: if l_invoice_status='CANCELLED' then
2480:

Line 2524: from Xla_Ae_Headers aip

2520: pv_period_from varchar2,pv_period_to varchar2, p_period_name date) return boolean
2521: is
2522: cursor cur_invoice is
2523: select trunc(accounting_date, 'mm') accounting_date
2524: from Xla_Ae_Headers aip
2525: where aip.ae_header_id = p_ae_header_id ;
2526:
2527: l_void_date date;
2528: l_invoice_status varchar2(30);

Line 2659: Xla_Ae_Headers Aeh,

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
2663: AND Gir.Je_Header_Id = Jeh.Je_Header_Id

Line 2708: Xla_Ae_Headers Aeh

2704: CURSOR inv_id_cur(ln_ae_header_id NUMBER) IS
2705: SELECT Aia.Invoice_Id Invoice_Id
2706: FROM Ap_Invoices_All Aia,
2707: Xla_Transaction_Entities Ent,
2708: Xla_Ae_Headers Aeh
2709: WHERE Ent.Application_Id = 200
2710: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
2711: AND Ent.Entity_Code = 'AP_INVOICES'
2712: AND Ent.Entity_Id = Aeh.Entity_Id

Line 2721: Xla_Ae_Headers Aeh

2717: FROM Ap_Invoices_All Aia,
2718: Ap_Checks_All Ach,
2719: Ap_Invoice_Payments_All Aip,
2720: Xla_Transaction_Entities Ent,
2721: Xla_Ae_Headers Aeh
2722: WHERE Ent.Application_Id = 200
2723: AND Aia.Invoice_Id = Aip.Invoice_Id
2724: AND Ach.Check_Id = Aip.Check_Id
2725: AND Ach.Check_Id = Ent.Source_Id_Int_1

Line 2811: Xla_Ae_Headers Aeh,

2807: Pa_Projects_All Pap,
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

Line 2891: Xla_Ae_Headers Aeh,

2887: FROM Ap_Invoices_All Aia,
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,

Line 2920: FROM Xla_Transaction_Entities Ent1, Xla_Ae_Headers Aeh1

2916: --if Yes, indicating that invoice id was derived from payment journal
2917: --else, invoice id was derived from invoice journal itself
2918: AND ((EXISTS
2919: (SELECT Aeh1.Ae_Header_Id
2920: FROM Xla_Transaction_Entities Ent1, Xla_Ae_Headers Aeh1
2921: WHERE Ent1.Entity_Code = 'AP_PAYMENTS'
2922: AND Ent1.Entity_Id = Aeh1.Entity_Id
2923: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2924: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id

Line 2928: FROM Xla_Transaction_Entities Ent1, Xla_Ae_Headers Aeh1

2924: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2925: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2926: ) OR NOT EXISTS
2927: (SELECT Aeh1.Ae_Header_Id
2928: FROM Xla_Transaction_Entities Ent1, Xla_Ae_Headers Aeh1
2929: WHERE Ent1.Entity_Code = 'AP_PAYMENTS'
2930: AND Ent1.Entity_Id = Aeh1.Entity_Id
2931: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2932: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id

Line 2977: Xla_Ae_Headers Aeh,

2973: DECODE(Aia.PAYMENT_STATUS_FLAG, 'Y', '1', '0') Clear_Flag,
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,

Line 3012: FROM Ap_Prepay_History_All Aph, Xla_Ae_Headers Aeh

3008:
3009: --Cursor for fetching prepaid invoice id
3010: CURSOR prepay_inv_id_cur(ln_invoice_id NUMBER, ln_ae_header_id NUMBER) IS
3011: SELECT Aph.Prepay_Invoice_Id
3012: FROM Ap_Prepay_History_All Aph, Xla_Ae_Headers Aeh
3013: WHERE Aph.Invoice_Id = ln_invoice_id --variable: ln_invoice_id
3014: AND Aph.Accounting_Event_Id = Aeh.Event_Id
3015: AND Aeh.Ae_Header_Id = ln_ae_header_id; --variable: ln_ae_header_id
3016:

Line 3021: Xla_Ae_Headers Aeh,

3017: --Cursor for fetching prepaid account number
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