APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TXL_AR_INV_LNS_V

Line 598: okl_txl_ar_inv_lns_v til,

594: xls.id xls_id
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

Line 612: okl_txl_ar_inv_lns_v til

608: xls.id xls_id
609: FROM okl_ext_sell_invs_v xsi,
610: okl_xtl_sell_invs_v xls,
611: okl_trx_ar_invoices_v tai,
612: okl_txl_ar_inv_lns_v til
613: WHERE til.tai_id = tai.id
614: AND xls.xsi_id_details = xsi.id
615: AND xls.til_id = til.id
616: AND tai.id = p_tai_id;

Line 632: FROM okl_txl_ar_inv_lns_v

628: WHERE id = p_tld_id;
629:
630: CURSOR reverse_csr2(p_til_id NUMBER) IS
631: SELECT receivables_invoice_id
632: FROM okl_txl_ar_inv_lns_v
633: WHERE id = p_til_id;
634:
635: -- Cursors to fetch Rule based data
636: CURSOR customer_id_csr(p_khr_id NUMBER) IS

Line 788: l_rounded_amount okl_txl_ar_inv_lns_v.amount%TYPE;

784:
785: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
786: l_precision fnd_currencies.PRECISION %TYPE;
787:
788: l_rounded_amount okl_txl_ar_inv_lns_v.amount%TYPE;
789:
790: --Start code added by pgomes on 20-NOV-2002
791: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
792: l_khr_id khr_id_type;

Line 3284: okl_txl_ar_inv_lns_v t2,

3280: t3.inventory_item_id inventory_item_id,
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'

Line 3334: okl_txl_ar_inv_lns_v t2,

3330: -- Start Bug 4673593
3331: t2.bank_acct_id bank_acct_id, -- End Bug 4673593 --bug 5160519,
3332: t1.qte_id qte_id --Termination Quote id --bug 5160519:end
3333: FROM okl_trx_ar_invoices_v t1,
3334: okl_txl_ar_inv_lns_v t2,
3335: okl_strm_type_v t4,
3336: okc_k_headers_b CHR
3337: WHERE t1.trx_status_code = 'SUBMITTED'
3338: AND t1.khr_id = CHR.id

Line 3384: okl_txl_ar_inv_lns_v t2,

3380: t3.inventory_item_id inventory_item_id,
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

Line 3440: okl_txl_ar_inv_lns_v t2,

3436: t2.bank_acct_id bank_acct_id, -- End Bug 4673593 --bug 5160519,
3437: t1.qte_id qte_id --Termination Quote id
3438: --bug 5160519:end
3439: FROM okl_trx_ar_invoices_v t1,
3440: okl_txl_ar_inv_lns_v t2,
3441: okl_strm_type_v t4,
3442: okc_k_headers_b CHR,
3443: OKL_PARALLEL_PROCESSES pws
3444: WHERE t1.trx_status_code = 'SUBMITTED'