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_TRANSACTION_ENTITIES

Line 742: Xla_Transaction_Entities Ent,

738:
739: CURSOR prepaid_account_num_cur IS
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

Line 894: FROM Xla_Transaction_Entities Ent1,

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
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

Line 904: Xla_Transaction_Entities Ent1,

900: AND Aeh1.Ledger_Id = pn_ledger_id), --parameter: pn_ledger_id
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'

Line 1662: Xla_Transaction_Entities Ent,

1658: --collecting invoice amount
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

Line 1699: Xla_Transaction_Entities Ent,

1695: 0)) Paid_Amount
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

Line 1740: Xla_Transaction_Entities Ent,

1736: AND Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
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

Line 1781: Xla_Transaction_Entities Ent,

1777: UNION
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

Line 1894: Xla_Transaction_Entities Ent,

1890: --collecting prepayment amount
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

Line 2707: Xla_Transaction_Entities Ent,

2703: --Step 2: Cursor for fetching invoice id
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'

Line 2720: Xla_Transaction_Entities Ent,

2716: SELECT Aia.Invoice_Id Invoice_Id
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

Line 2810: Xla_Transaction_Entities Ent,

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

Line 2890: Xla_Transaction_Entities Ent,

2886: '' Remittance_Bill_Number
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,

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 2976: Xla_Transaction_Entities Ent,

2972: '' Payment_Date,
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,