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 XLA_TRANSACTION_ENTITIES

Line 632: Xla_Transaction_Entities Ent,

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,
636: Gl_Je_Headers Jeh

Line 672: Xla_Transaction_Entities Ent,

668: Ael.Entered_Dr Entered_Dr,
669: Ael.Entered_Cr Entered_Cr
670: FROM AR_CASH_RECEIPTS_ALL Acr,
671: AR_RECEIVABLE_APPLICATIONS_ALL App,
672: Xla_Transaction_Entities Ent,
673: Xla_Ae_Headers Aeh,
674: Xla_Ae_Lines Ael,
675: Gl_Je_Headers Jeh,
676: Gl_Import_References Gir

Line 749: Xla_Transaction_Entities Ent,

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,
753: Gl_Je_Headers Jeh

Line 783: Xla_Transaction_Entities Ent,

779: Ael.Accounted_Cr Accounted_Cr,
780: Ael.Entered_Dr Entered_Dr,
781: Ael.Entered_Cr Entered_Cr
782: FROM AR_ADJUSTMENTS_ALL Adj,
783: Xla_Transaction_Entities Ent,
784: Xla_Ae_Headers Aeh,
785: Xla_Ae_Lines Ael,
786: Gl_Import_References Gir,
787: Gl_Je_Headers Jeh

Line 1739: Xla_Transaction_Entities Ent,

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
1743: AND Ent.Entity_Code = 'TRANSACTIONS'

Line 1756: Xla_Transaction_Entities Ent,

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,
1756: Xla_Transaction_Entities Ent,
1757: Xla_Ae_Headers Aeh
1758: WHERE Ent.Application_Id = 222
1759: AND Acr.Cash_Receipt_Id = App.Cash_Receipt_Id
1760: AND Acr.Cash_Receipt_Id = Ent.Source_Id_Int_1

Line 1769: Xla_Transaction_Entities Ent,

1765: AND App.Applied_Customer_Trx_Id IS NOT NULL
1766: UNION
1767: SELECT DISTINCT Adj.Customer_Trx_Id Customer_Trx_Id
1768: FROM AR_ADJUSTMENTS_ALL Adj,
1769: Xla_Transaction_Entities Ent,
1770: Xla_Ae_Headers Aeh
1771: WHERE Ent.Application_Id = 222
1772: AND Adj.Adjustment_Id = Ent.Source_Id_Int_1
1773: AND Ent.Entity_Code = 'ADJUSTMENTS'

Line 1780: Xla_Transaction_Entities Ent,

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
1784: AND Ent.Entity_Code = 'TRANSACTIONS'

Line 1924: Xla_Transaction_Entities Ent,

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,
1928: Gl_Je_Headers Jeh,

Line 1986: Xla_Transaction_Entities Ent,

1982: Acr.Receipt_Method_Id Settlement_Method_Number,
1983: TO_CHAR(Acr.Receipt_Date,'YYYYMMDD') Payment_Date
1984: FROM AR_CASH_RECEIPTS_ALL Acr,
1985: AR_RECEIVABLE_APPLICATIONS_ALL App,
1986: Xla_Transaction_Entities Ent,
1987: Xla_Ae_Headers Aeh,
1988: Xla_Ae_Lines Ael,
1989: Gl_Je_Headers Jeh,
1990: Gl_Import_References Gir,

Line 2023: FROM Xla_Transaction_Entities Ent1,

2019: --only this receipt need be exported.
2020: --NOT EXISTS means that the customer_trx_id is from Transaction,so
2021: --all the receipt applied to it need be exported.
2022: AND ((EXISTS(SELECT Aeh1.Ae_Header_Id
2023: FROM Xla_Transaction_Entities Ent1,
2024: Xla_Ae_Headers Aeh1
2025: WHERE Ent1.Entity_Code = 'RECEIPTS'
2026: AND Ent1.Entity_Id = Aeh1.Entity_Id
2027: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2032: FROM Xla_Transaction_Entities Ent1,

2028: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2029: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2030: )
2031: OR NOT EXISTS(SELECT Aeh1.Ae_Header_Id
2032: FROM Xla_Transaction_Entities Ent1,
2033: Xla_Ae_Headers Aeh1
2034: WHERE Ent1.Entity_Code = 'RECEIPTS'
2035: AND Ent1.Entity_Id = Aeh1.Entity_Id
2036: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2041: FROM Xla_Transaction_Entities Ent2,

2037: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2038: )
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

Line 2053: FROM Xla_Transaction_Entities Ent3,

2049: AND Aeh2.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2050: AND Rct2.Previous_Customer_Trx_Id IS NOT NULL) --variable: ln_ae_header_id
2051: --NOT EXISTS means that the customer_trx_id not from Adjustment
2052: AND NOT EXISTS(SELECT Aeh3.Ae_Header_Id
2053: FROM Xla_Transaction_Entities Ent3,
2054: Xla_Ae_Headers Aeh3
2055: WHERE Ent3.Entity_Code = 'ADJUSTMENTS'
2056: AND Ent3.Entity_Id = Aeh3.Entity_Id
2057: AND Aeh3.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2115: Xla_Transaction_Entities Ent,

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,
2119: Gl_Je_Headers Jeh,

Line 2154: FROM Xla_Transaction_Entities Ent1,

2150: --only this creditmemo need be exported.
2151: --NOT EXISTS means that the customer_trx_id is from Transaction,so
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

Line 2167: FROM Xla_Transaction_Entities Ent1,

2163: AND Rct.Previous_Customer_Trx_Id IS NOT NULL) --variable: ln_ae_header_id
2164: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
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

Line 2180: FROM Xla_Transaction_Entities Ent2,

2176: AND Rct.Previous_Customer_Trx_Id IS NOT NULL) --variable: ln_ae_header_id
2177: )
2178: --NOT EXISTS means that the customer_trx_id not from Receipt
2179: AND NOT EXISTS(SELECT Aeh2.Ae_Header_Id
2180: FROM Xla_Transaction_Entities Ent2,
2181: Xla_Ae_Headers Aeh2
2182: WHERE Ent2.Entity_Code = 'RECEIPTS'
2183: AND Ent2.Entity_Id = Aeh2.Entity_Id
2184: AND Aeh2.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2188: FROM Xla_Transaction_Entities Ent3,

2184: AND Aeh2.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2185: AND Aeh2.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2186: --NOT EXISTS means that the customer_trx_id not from Adjustment
2187: AND NOT EXISTS(SELECT Aeh3.Ae_Header_Id
2188: FROM Xla_Transaction_Entities Ent3,
2189: Xla_Ae_Headers Aeh3
2190: WHERE Ent3.Entity_Code = 'ADJUSTMENTS'
2191: AND Ent3.Entity_Id = Aeh3.Entity_Id
2192: AND Aeh3.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2215: Xla_Transaction_Entities Ent,

2211: Adj.Adjustment_Id Adjustment_Id,
2212: Adj.Comments Description,
2213: TO_CHAR(Adj.Gl_Date,'YYYYMMDD') Applied_Date
2214: FROM AR_ADJUSTMENTS_ALL Adj,
2215: Xla_Transaction_Entities Ent,
2216: Xla_Ae_Headers Aeh,
2217: Xla_Ae_Lines Ael,
2218: Gl_Import_References Gir,
2219: Gl_Je_Headers Jeh,

Line 2248: FROM Xla_Transaction_Entities Ent1,

2244: --only this adjust need be exported.
2245: --NOT EXISTS means that the customer_trx_id is from Transaction,so
2246: --all Adjustments based on it need be exported.
2247: AND ((EXISTS(SELECT Aeh1.Ae_Header_Id
2248: FROM Xla_Transaction_Entities Ent1,
2249: Xla_Ae_Headers Aeh1
2250: WHERE Ent1.Entity_Code = 'ADJUSTMENTS'
2251: AND Ent1.Entity_Id = Aeh1.Entity_Id
2252: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2257: FROM Xla_Transaction_Entities Ent1,

2253: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2254: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2255: )
2256: OR NOT EXISTS(SELECT Aeh1.Ae_Header_Id
2257: FROM Xla_Transaction_Entities Ent1,
2258: Xla_Ae_Headers Aeh1
2259: WHERE Ent1.Entity_Code = 'ADJUSTMENTS'
2260: AND Ent1.Entity_Id = Aeh1.Entity_Id
2261: AND Aeh1.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 2266: FROM Xla_Transaction_Entities Ent2,

2262: AND Aeh1.Ae_Header_Id = ln_ae_header_id) --variable: ln_ae_header_id
2263: )
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

Line 2278: FROM Xla_Transaction_Entities Ent3,

2274: AND Aeh2.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2275: AND Rct2.Previous_Customer_Trx_Id IS NOT NULL) --variable: ln_ae_header_id
2276: --NOT EXISTS means that the customer_trx_id not from Receipt
2277: AND NOT EXISTS(SELECT Aeh3.Ae_Header_Id
2278: FROM Xla_Transaction_Entities Ent3,
2279: Xla_Ae_Headers Aeh3
2280: WHERE Ent3.Entity_Code = 'RECEIPTS'
2281: AND Ent3.Entity_Id = Aeh3.Entity_Id
2282: AND Aeh3.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id