APPS.OKL_CASH_RECEIPT dependencies on OKL_CNSLD_AR_STRMS_V

Line 213: FROM okl_cnsld_ar_strms_v

209:
210: IF l_record_count > 0 THEN
211:
212: SELECT receivables_invoice_id INTO l_customer_trx_id
213: FROM okl_cnsld_ar_strms_v
214: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
215:
216: SELECT bill_to_site_use_id INTO l_customer_site_use_id
217: FROM ra_customer_trx_all

Line 214: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;

210: IF l_record_count > 0 THEN
211:
212: SELECT receivables_invoice_id INTO l_customer_trx_id
213: FROM okl_cnsld_ar_strms_v
214: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
215:
216: SELECT bill_to_site_use_id INTO l_customer_site_use_id
217: FROM ra_customer_trx_all
218: WHERE customer_trx_id = l_customer_trx_id;

Line 269: FROM okl_cnsld_ar_strms_v

265:
266: ar_invoice_num := NULL;
267:
268: SELECT receivables_invoice_id INTO l_customer_trx_id
269: FROM okl_cnsld_ar_strms_v
270: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
271:
272: /* Modified select statement to address bug 4510824 */
273: SELECT max(trx_date), invoice_number INTO l_xcav_tbl(i).trx_date, ar_invoice_num

Line 270: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;

266: ar_invoice_num := NULL;
267:
268: SELECT receivables_invoice_id INTO l_customer_trx_id
269: FROM okl_cnsld_ar_strms_v
270: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
271:
272: /* Modified select statement to address bug 4510824 */
273: SELECT max(trx_date), invoice_number INTO l_xcav_tbl(i).trx_date, ar_invoice_num
274: FROM okl_xtl_csh_apps_v

Line 817: FROM okl_cnsld_ar_strms_v

813:
814: ----------------------------------------------------------------
815:
816: SELECT receivables_invoice_id INTO l_customer_trx_id
817: FROM okl_cnsld_ar_strms_v
818: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
819:
820: SELECT bill_to_site_use_id INTO l_customer_site_use_id
821: FROM ra_customer_trx_all

Line 818: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;

814: ----------------------------------------------------------------
815:
816: SELECT receivables_invoice_id INTO l_customer_trx_id
817: FROM okl_cnsld_ar_strms_v
818: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
819:
820: SELECT bill_to_site_use_id INTO l_customer_site_use_id
821: FROM ra_customer_trx_all
822: WHERE customer_trx_id = l_customer_trx_id;

Line 910: FROM okl_cnsld_ar_strms_v

906: i := i + 1;
907: LOOP
908:
909: SELECT receivables_invoice_id INTO l_customer_trx_id
910: FROM okl_cnsld_ar_strms_v
911: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
912:
913: SELECT trx_date INTO l_xcav_tbl(i).trx_date
914: FROM okl_xtl_csh_apps_v

Line 911: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;

907: LOOP
908:
909: SELECT receivables_invoice_id INTO l_customer_trx_id
910: FROM okl_cnsld_ar_strms_v
911: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
912:
913: SELECT trx_date INTO l_xcav_tbl(i).trx_date
914: FROM okl_xtl_csh_apps_v
915: WHERE lsm_id = l_xcav_tbl(i).lsm_id