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_AE_LINES

Line 634: Xla_Ae_Lines Ael,

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
637: WHERE Rct.Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
638: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID

Line 674: Xla_Ae_Lines Ael,

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
677: WHERE Acr.Cash_Receipt_Id = App.Cash_Receipt_Id
678: AND App.Applied_Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id

Line 701: FROM Xla_Ae_Lines Ael,

697: Ael.Accounted_Dr Accounted_Dr,
698: Ael.Accounted_Cr Accounted_Cr,
699: Ael.Entered_Dr Entered_Dr,
700: Ael.Entered_Cr Entered_Cr
701: FROM Xla_Ae_Lines Ael,
702: Gl_Import_References Gir,
703: Gl_Je_Headers Jeh
704: WHERE Ael.Accounting_Class_Code = 'RECEIVABLE'
705: AND Ael.Application_Id = 222

Line 751: Xla_Ae_Lines Ael,

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
754: WHERE Rct.Previous_Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
755: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID

Line 785: Xla_Ae_Lines Ael,

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
788: WHERE Adj.Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
789: --SLA condition

Line 1261: Xla_Ae_Lines Ael,

1257: IS
1258: SELECT DISTINCT Account_Number FROM(
1259: SELECT Jab.Account_Segment Account_Number
1260: FROM Xla_Ae_Headers Aeh,
1261: Xla_Ae_Lines Ael,
1262: Ja_Cn_Code_Combination_v Jcc,
1263: Ja_Cn_Account_Balances Jab
1264: WHERE Jab.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1265: AND Jab.Legal_Entity_Id = pn_legal_entity_id --parameter: pn_legal_entity_id

Line 1463: XLA_AE_LINES ael,

1459: ,'N') no_trans_flag
1460: FROM GL_JE_HEADERS jeh,
1461: GL_JE_LINES jel,
1462: GL_IMPORT_REFERENCES gir,
1463: XLA_AE_LINES ael,
1464: XLA_AE_HEADERS aeh,
1465: JA_CN_CODE_COMBINATION_V jcc,
1466: HZ_CUST_ACCOUNTS cust,
1467: HZ_PARTIES part,

Line 1700: XLA_AE_LINES ael,

1696: jeh.default_effective_date
1697: FROM GL_JE_HEADERS jeh,
1698: GL_JE_LINES jel,
1699: GL_IMPORT_REFERENCES gir,
1700: XLA_AE_LINES ael,
1701: XLA_AE_HEADERS aeh,
1702: JA_CN_CODE_COMBINATION_V jcc,
1703: HZ_CUST_ACCOUNTS cust,
1704: HZ_PARTIES part,

Line 1926: Xla_Ae_Lines Ael,

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,
1929: Gl_Ledgers Gl,
1930: Gl_Periods Gp,

Line 1988: Xla_Ae_Lines Ael,

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,
1991: Gl_Ledgers Gl,
1992: Gl_Periods Gp,

Line 2117: Xla_Ae_Lines Ael,

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,
2120: Gl_Ledgers Gl,
2121: Gl_Periods Gp,

Line 2217: Xla_Ae_Lines Ael,

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,
2220: Gl_Ledgers Gl,
2221: Gl_Periods Gp

Line 2311: FROM Xla_Ae_Lines Ael,

2307: (ln_ae_header_id NUMBER)
2308: IS
2309: SELECT SUM(NVL(Ael.Accounted_Dr,0) + NVL(-1 * Ael.Accounted_Cr,0)) Functional_Amount,
2310: SUM(NVL(Ael.Entered_Dr,0) + NVL(-1 * Ael.Entered_Cr, 0)) Entered_Amount
2311: FROM Xla_Ae_Lines Ael,
2312: Xla_Ae_Headers Aeh
2313: WHERE Ael.Ae_Header_Id = Aeh.Ae_Header_Id
2314: AND Ael.Accounting_Class_Code = 'RECEIVABLE'
2315: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id

Line 2331: FROM Xla_Ae_Lines Ael

2327: ,ln_customer_trx_id NUMBER)
2328: IS
2329: SELECT SUM(NVL(Ael.Accounted_Dr,0) + NVL(-1 * Ael.Accounted_Cr,0)) Functional_Amount,
2330: SUM(NVL(Ael.Entered_Dr,0) + NVL(-1 * Ael.Entered_Cr, 0)) Entered_Amount
2331: FROM Xla_Ae_Lines Ael
2332: WHERE Ael.Accounting_Class_Code = 'RECEIVABLE'
2333: AND Ael.Application_Id = 222
2334: AND (Ael.Ae_Header_Id,Ael.Ae_Line_Num) IN
2335: (SELECT Xdl.Ae_Header_Id,

Line 2365: FROM Xla_Ae_Lines Ael,

2361: ,ln_ae_line_num NUMBER)
2362: IS
2363: SELECT SUM(NVL(Ael.Accounted_Dr,0) + NVL(-1 * Ael.Accounted_Cr,0)) Functional_Amount,
2364: SUM(NVL(Ael.Entered_Dr,0) + NVL(-1 * Ael.Entered_Cr, 0)) Entered_Amount
2365: FROM Xla_Ae_Lines Ael,
2366: Xla_Ae_Headers Aeh
2367: WHERE Ael.Ae_Header_Id = Aeh.Ae_Header_Id
2368: AND Ael.Accounting_Class_Code = 'RECEIVABLE'
2369: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id