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_IMPORT_REFERENCES

Line 1703: Gl_Import_References Gir

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
1707: AND Aip.Accounting_Date <= (SELECT DISTINCT Gp.End_Date

Line 1744: Gl_Import_References Gir

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
1748: FROM Gl_Ledgers Gl, Gl_Periods Gp

Line 1785: Gl_Import_References Gir

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
1789: AND Ent.Application_Id = 200

Line 1929: Gl_Import_References Gir

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
1933: AND Aeh.Ae_Header_Id = Ael.Ae_Header_Id

Line 2245: Gl_Import_References Gir,

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,
2249: Xla_Ae_Lines Ael,

Line 2654: Gl_Import_References Gir,

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,
2658: Xla_Ae_Lines Ael,

Line 2814: Gl_Import_References Gir

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(+)
2818: AND Aia.Quick_Po_Header_Id = Pha.Po_Header_Id(+)

Line 2894: Gl_Import_References Gir,

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
2898: WHERE Aia.Invoice_Id = Aip.Invoice_Id

Line 2980: Gl_Import_References Gir,

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
2984: WHERE Aia.Invoice_Id = ln_invoice_id -- variable: ln_invoice_id