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_AR_RBD_EXPORT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 631: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,

627: IS
628: SELECT SUM(NVL(Ael.Accounted_Dr,0) + NVL(-1 * Ael.Accounted_Cr,0)) Functional_Amount,
629: SUM(NVL(Ael.Entered_Dr,0) + NVL(-1 * Ael.Entered_Cr, 0)) Entered_Amount
630: FROM RA_CUSTOMER_TRX_ALL Rct,
631: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,
632: Xla_Transaction_Entities Ent,
633: Xla_Ae_Headers Aeh,
634: Xla_Ae_Lines Ael,
635: Gl_Import_References Gir,

Line 748: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,

744: Ael.Accounted_Cr Accounted_Cr,
745: Ael.Entered_Dr Entered_Dr,
746: Ael.Entered_Cr Entered_Cr
747: FROM RA_CUSTOMER_TRX_ALL Rct,
748: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,
749: Xla_Transaction_Entities Ent,
750: Xla_Ae_Headers Aeh,
751: Xla_Ae_Lines Ael,
752: Gl_Import_References Gir,

Line 1751: RA_CUST_TRX_LINE_GL_DIST_ALL Gd

1747: AND Rct.Previous_Customer_Trx_Id IS NULL --Not On-account Credit Memo should not be export seperately
1748: UNION
1749: SELECT DISTINCT Rcta.Customer_Trx_Id Customer_Trx_Id
1750: FROM RA_CUSTOMER_TRX_ALL Rcta,
1751: RA_CUST_TRX_LINE_GL_DIST_ALL Gd
1752: WHERE Rcta.Customer_Trx_Id IN (
1753: SELECT DISTINCT App.Applied_Customer_Trx_Id Customer_Trx_Id
1754: FROM AR_CASH_RECEIPTS_ALL Acr,
1755: AR_RECEIVABLE_APPLICATIONS_ALL App,

Line 1817: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,

1813: IS
1814: --from Transaction
1815: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1816: FROM RA_CUSTOMER_TRX_ALL Rct,
1817: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,
1818: Gl_Ledgers Gl,
1819: Gl_Periods Gp
1820: WHERE Rct.Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1821: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id

Line 1848: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,

1844: UNION
1845: --from Credit Memo
1846: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1847: FROM RA_CUSTOMER_TRX_ALL Rct,
1848: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,
1849: Gl_Ledgers Gl,
1850: Gl_Periods Gp
1851: WHERE Rct.Previous_Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1852: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id

Line 1923: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,

1919: 'ATTRIBUTE11',Rct.ATTRIBUTE11,'ATTRIBUTE12',Rct.ATTRIBUTE12,
1920: 'ATTRIBUTE13',Rct.ATTRIBUTE13,'ATTRIBUTE14',Rct.ATTRIBUTE14,
1921: 'ATTRIBUTE15',Rct.ATTRIBUTE15,NULL), NULL)*/ Remittance_Bill_Number
1922: FROM RA_CUSTOMER_TRX_ALL Rct,
1923: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,
1924: Xla_Transaction_Entities Ent,
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Gl_Import_References Gir,

Line 2114: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,

2110: 'ATTRIBUTE11',Rct.ATTRIBUTE11,'ATTRIBUTE12',Rct.ATTRIBUTE12,
2111: 'ATTRIBUTE13',Rct.ATTRIBUTE13,'ATTRIBUTE14',Rct.ATTRIBUTE14,
2112: 'ATTRIBUTE15',Rct.ATTRIBUTE15,NULL), NULL)*/ Remittance_Bill_Number
2113: FROM RA_CUSTOMER_TRX_ALL Rct,
2114: RA_CUST_TRX_LINE_GL_DIST_ALL Rctlgd,
2115: Xla_Transaction_Entities Ent,
2116: Xla_Ae_Headers Aeh,
2117: Xla_Ae_Lines Ael,
2118: Gl_Import_References Gir,