APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 671: AR_RECEIVABLE_APPLICATIONS_ALL App,

667: Ael.Accounted_Cr Accounted_Cr,
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,

Line 709: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,

705: AND Ael.Application_Id = 222
706: AND (Ael.Ae_Header_Id,Ael.Ae_Line_Num) IN
707: (SELECT Xdl.Ae_Header_Id,
708: Xdl.Ae_Line_Num
709: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,
710: Xla_Ae_Headers Aeh,
711: Xla_Distribution_Links Xdl,
712: Ar_Distributions_All Ada
713: WHERE App.event_id = Aeh.event_id

Line 1755: AR_RECEIVABLE_APPLICATIONS_ALL App,

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,
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

Line 1831: --for Receipts from AR_RECEIVABLE_APPLICATIONS_ALL and the status must be Applied

1827: AND Gd.gl_date BETWEEN Gp.start_date AND Gp.End_date
1828: AND ((gp.start_date BETWEEN ld_start_date AND ld_end_date) AND
1829: (gp.end_date BETWEEN ld_start_date AND ld_end_date))
1830: UNION
1831: --for Receipts from AR_RECEIVABLE_APPLICATIONS_ALL and the status must be Applied
1832: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1833: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,
1834: Gl_Ledgers Gl,
1835: Gl_Periods Gp

Line 1833: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,

1829: (gp.end_date BETWEEN ld_start_date AND ld_end_date))
1830: UNION
1831: --for Receipts from AR_RECEIVABLE_APPLICATIONS_ALL and the status must be Applied
1832: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1833: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,
1834: Gl_Ledgers Gl,
1835: Gl_Periods Gp
1836: WHERE App.Applied_Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1837: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id

Line 1985: AR_RECEIVABLE_APPLICATIONS_ALL App,

1981: Acr.Receipt_Number Transaction_Number,
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,

Line 2337: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,

2333: AND Ael.Application_Id = 222
2334: AND (Ael.Ae_Header_Id,Ael.Ae_Line_Num) IN
2335: (SELECT Xdl.Ae_Header_Id,
2336: Xdl.Ae_Line_Num
2337: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,
2338: Xla_Ae_Headers Aeh,
2339: Xla_Distribution_Links Xdl,
2340: Ar_Distributions_All Ada
2341: WHERE App.event_id = Aeh.event_id