APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 670: FROM AR_CASH_RECEIPTS_ALL Acr,

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

Line 1111: ' FROM AR_CASH_RECEIPTS_ALL'||

1107:
1108: IF lv_attribute_column4bill_num IS NOT NULL --Defined in DFF assignment form
1109: THEN
1110: lv_cursor_sql := 'SELECT '||lv_attribute_column4bill_num||
1111: ' FROM AR_CASH_RECEIPTS_ALL'||
1112: ' WHERE Cash_Receipt_Id ='||pn_receipt_id||
1113: ' AND Attribute_Category='''||lv_context_code||'''';
1114:
1115: OPEN v_bill_num_row for lv_cursor_sql;

Line 1754: FROM AR_CASH_RECEIPTS_ALL Acr,

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,
1756: Xla_Transaction_Entities Ent,
1757: Xla_Ae_Headers Aeh
1758: WHERE Ent.Application_Id = 222

Line 1984: FROM AR_CASH_RECEIPTS_ALL Acr,

1980: Acr.Type Transaction_Type_Number,
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,