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_CUSTOMER_TRX_ALL

Line 630: FROM RA_CUSTOMER_TRX_ALL Rct,

626: CURSOR trx_amount_cur
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,

Line 747: FROM RA_CUSTOMER_TRX_ALL Rct,

743: Ael.Accounted_Dr Accounted_Dr,
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,

Line 1738: FROM RA_CUSTOMER_TRX_ALL Rct,

1734: CURSOR customer_trx_id_cur
1735: (ln_ae_header_id NUMBER)
1736: IS
1737: SELECT DISTINCT Rct.Customer_Trx_Id Customer_Trx_Id
1738: FROM RA_CUSTOMER_TRX_ALL Rct,
1739: Xla_Transaction_Entities Ent,
1740: Xla_Ae_Headers Aeh
1741: WHERE Ent.Application_Id = 222
1742: AND Rct.Customer_Trx_Id = Ent.Source_Id_Int_1

Line 1750: FROM RA_CUSTOMER_TRX_ALL Rcta,

1746: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
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,

Line 1779: FROM RA_CUSTOMER_TRX_ALL Rct,

1775: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
1776: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1777: UNION
1778: SELECT DISTINCT Rct.Previous_Customer_Trx_Id Customer_Trx_Id
1779: FROM RA_CUSTOMER_TRX_ALL Rct,
1780: Xla_Transaction_Entities Ent,
1781: Xla_Ae_Headers Aeh
1782: WHERE Ent.Application_Id = 222
1783: AND Rct.Customer_Trx_Id = Ent.Source_Id_Int_1

Line 1816: FROM RA_CUSTOMER_TRX_ALL Rct,

1812: (ln_customer_trx_id NUMBER)
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

Line 1847: FROM RA_CUSTOMER_TRX_ALL Rct,

1843: (gp.end_date BETWEEN ld_start_date AND ld_end_date))
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

Line 1922: FROM RA_CUSTOMER_TRX_ALL Rct,

1918: 'ATTRIBUTE9',Rct.ATTRIBUTE9,'ATTRIBUTE10',Rct.ATTRIBUTE10,
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,

Line 2043: RA_CUSTOMER_TRX_ALL Rct2

2039: --NOT EXISTS means that the customer_trx_id not from CreditMemo
2040: AND NOT EXISTS(SELECT Aeh2.Ae_Header_Id
2041: FROM Xla_Transaction_Entities Ent2,
2042: Xla_Ae_Headers Aeh2,
2043: RA_CUSTOMER_TRX_ALL Rct2
2044: WHERE Ent2.Application_Id = 222
2045: AND Rct2.Customer_Trx_Id = Ent2.Source_Id_Int_1
2046: AND Ent2.Entity_Code = 'TRANSACTIONS'
2047: AND Ent2.Entity_Id = Aeh2.Entity_Id

Line 2113: FROM RA_CUSTOMER_TRX_ALL Rct,

2109: 'ATTRIBUTE9',Rct.ATTRIBUTE9,'ATTRIBUTE10',Rct.ATTRIBUTE10,
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,

Line 2156: RA_CUSTOMER_TRX_ALL Rct

2152: --all the creditmemo applied to it need be exported.
2153: AND ((EXISTS(SELECT Aeh1.Ae_Header_Id
2154: FROM Xla_Transaction_Entities Ent1,
2155: Xla_Ae_Headers Aeh1,
2156: RA_CUSTOMER_TRX_ALL Rct
2157: WHERE Ent1.Application_Id = 222
2158: AND Rct.Customer_Trx_Id = Ent1.Source_Id_Int_1
2159: AND Ent1.Entity_Code = 'TRANSACTIONS'
2160: AND Ent1.Entity_Id = Aeh1.Entity_Id

Line 2169: RA_CUSTOMER_TRX_ALL Rct

2165: )
2166: OR NOT EXISTS(SELECT Aeh1.Ae_Header_Id
2167: FROM Xla_Transaction_Entities Ent1,
2168: Xla_Ae_Headers Aeh1,
2169: RA_CUSTOMER_TRX_ALL Rct
2170: WHERE Ent1.Application_Id = 222
2171: AND Rct.Customer_Trx_Id = Ent1.Source_Id_Int_1
2172: AND Ent1.Entity_Code = 'TRANSACTIONS'
2173: AND Ent1.Entity_Id = Aeh1.Entity_Id

Line 2268: RA_CUSTOMER_TRX_ALL Rct2

2264: --NOT EXISTS means that the customer_trx_id not from CreditMemo
2265: AND NOT EXISTS(SELECT Aeh2.Ae_Header_Id
2266: FROM Xla_Transaction_Entities Ent2,
2267: Xla_Ae_Headers Aeh2,
2268: RA_CUSTOMER_TRX_ALL Rct2
2269: WHERE Ent2.Application_Id = 222
2270: AND Rct2.Customer_Trx_Id = Ent2.Source_Id_Int_1
2271: AND Ent2.Entity_Code = 'TRANSACTIONS'
2272: AND Ent2.Entity_Id = Aeh2.Entity_Id