APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TXD_AR_LN_DTLS_V

Line 599: okl_txd_ar_ln_dtls_v tld

595: FROM okl_ext_sell_invs_v xsi,
596: okl_xtl_sell_invs_v xls,
597: okl_trx_ar_invoices_v tai,
598: okl_txl_ar_inv_lns_v til,
599: okl_txd_ar_ln_dtls_v tld
600: WHERE til.tai_id = tai.id
601: AND tld.til_id_details = til.id
602: AND xls.xsi_id_details = xsi.id
603: AND xls.tld_id = tld.id

Line 627: FROM okl_txd_ar_ln_dtls_v

623: i NUMBER;
624: l_recv_inv_id NUMBER;
625: CURSOR reverse_csr1(p_tld_id NUMBER) IS
626: SELECT receivables_invoice_id
627: FROM okl_txd_ar_ln_dtls_v
628: WHERE id = p_tld_id;
629:
630: CURSOR reverse_csr2(p_til_id NUMBER) IS
631: SELECT receivables_invoice_id

Line 3285: okl_txd_ar_ln_dtls_v t3,

3281: -- End changes on remarketing by fmiao on 10/18/04 --
3282: NVL(t3.inventory_org_id, t2.inventory_org_id) inventory_org_id
3283: FROM okl_trx_ar_invoices_v t1,
3284: okl_txl_ar_inv_lns_v t2,
3285: okl_txd_ar_ln_dtls_v t3,
3286: okl_strm_type_v t4,
3287: okc_k_headers_b CHR
3288: WHERE t1.trx_status_code = 'SUBMITTED'
3289: AND t1.khr_id = CHR.id

Line 3385: okl_txd_ar_ln_dtls_v t3,

3381: -- End changes on remarketing by fmiao on 10/18/04 --
3382: NVL(t3.inventory_org_id, t2.inventory_org_id) inventory_org_id
3383: FROM okl_trx_ar_invoices_v t1,
3384: okl_txl_ar_inv_lns_v t2,
3385: okl_txd_ar_ln_dtls_v t3,
3386: okl_strm_type_v t4,
3387: okc_k_headers_b CHR,
3388: OKL_PARALLEL_PROCESSES pws
3389: WHERE t1.trx_status_code = 'SUBMITTED'

Line 3451: FROM okl_txd_ar_ln_dtls_v t3

3447: AND t2.tai_id = t1.id
3448: AND t4.id = t2.sty_id
3449: AND NOT EXISTS
3450: (SELECT *
3451: FROM okl_txd_ar_ln_dtls_v t3
3452: WHERE t3.til_id_details = t2.id)
3453: -- parallel process
3454: AND pws.object_type = 'PREP_CONTRACT'
3455: AND pws.object_value = CHR.contract_number