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 GL_JE_HEADERS

Line 1702: Gl_Je_Headers Jeh,

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

Line 1743: Gl_Je_Headers Jeh,

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 <=
1747: (SELECT DISTINCT Gp.End_Date

Line 1784: Gl_Je_Headers Jeh,

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'
1788: --SLA condition

Line 1928: Gl_Je_Headers Jeh,

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
1931: AND Aph.Accounting_Event_Id = Aeh.Event_Id
1932: --SLA condition

Line 2244: Gl_Je_Headers Jeh,

2240: --getting no invoice or payment flag
2241: CURSOR no_trans_flag_cur(ln_supplier_id NUMBER) IS
2242: SELECT DECODE(COUNT(*), 0, 'Y', 'N') no_trans_flag
2243: FROM Gl_Je_Lines Jel,
2244: Gl_Je_Headers Jeh,
2245: Gl_Import_References Gir,
2246: Ja_Cn_Code_Combination_v Jcc,
2247: Gl_Ledgers Gl,
2248: Gl_Periods Gp,

Line 2653: Gl_Je_Headers Jeh,

2649: Gp.Period_Num Accounting_Period_Number,
2650: Jeh.Je_Category Journal_Category_Number,
2651: Fcv.Name Functional_Currency
2652: FROM Gl_Je_Lines Jel,
2653: Gl_Je_Headers Jeh,
2654: Gl_Import_References Gir,
2655: Ja_Cn_Code_Combination_v Jcc,
2656: Gl_Ledgers Gl,
2657: Gl_Periods Gp,

Line 2813: Gl_Je_Headers Jeh,

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
2817: AND Aia.Project_Id = Pap.Project_Id(+)

Line 2893: Gl_Je_Headers Jeh,

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,
2897: Fnd_Currencies_Vl Fcv

Line 2979: Gl_Je_Headers Jeh,

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,
2983: Fnd_Currencies_Vl Fcv