DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1001: ra_Customer_trx_Lines_All cUst_trx_Lines ,

997: FROM
998: okl_bpd_tld_ar_lines_v TLD,
999: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1000: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,
1001: ra_Customer_trx_Lines_All cUst_trx_Lines ,
1002: ar_Activity_Details arl
1003: WHERE
1004: TLD.TLD_ID = p_tld_id AND
1005: PMTSCH.customer_trx_id = TLD.customer_trx_id AND

Line 1077: ra_customer_trx_lines_all ac

1073: TLD.LINE_amount AMOUNT
1074: FROM okl_bpd_tld_ar_lines_v TLD,
1075: okl_receipt_applications_uv ARAPP,
1076: ar_distributions_all ad ,
1077: ra_customer_trx_lines_all ac
1078: WHERE TLD.TLD_ID = p_tld_id
1079: AND ARAPP.LINE_APPLIED > 0
1080: AND NVL(ARAPP.customer_trx_line_id, TLD.customer_trx_line_id) = TLD.customer_trx_line_id
1081: AND ARAPP.customer_trx_id = TLD.customer_trx_id