APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TRX_AR_INVOICES_V

Line 55: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;

51: tai_id_tbl tai_id_tbl_type;
52:
53: l_commit_cnt NUMBER := 0;
54: l_commit_cnt2 NUMBER := 0;
55: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
56: l_max_commit_cnt NUMBER := 500;
57:
58: --fmiao 5209209 change end
59:

Line 597: okl_trx_ar_invoices_v tai,

593: SELECT xsi.id xsi_id,
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

Line 611: okl_trx_ar_invoices_v tai,

607: SELECT xsi.id xsi_id,
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

Line 3283: FROM okl_trx_ar_invoices_v t1,

3279: -- Start changes on remarketing by fmiao on 10/18/04 --
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

Line 3333: FROM okl_trx_ar_invoices_v t1,

3329: t2.inventory_org_id inventory_org_id,
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'

Line 3383: FROM okl_trx_ar_invoices_v t1,

3379: -- Start changes on remarketing by fmiao on 10/18/04 --
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,

Line 3439: FROM okl_trx_ar_invoices_v t1,

3435: -- Start Bug 4673593
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

Line 3496: submitted_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;

3492: l_succ_cnt NUMBER;
3493: l_op_unit_name hr_operating_units.name%TYPE;
3494: lx_msg_data VARCHAR2(450);
3495: l_msg_index_out NUMBER :=0;
3496: submitted_sts okl_trx_ar_invoices_v.trx_status_code%TYPE;
3497: l_end_of_records VARCHAR2(1);
3498:
3499: BEGIN
3500: l_return_status := Okl_Api.START_ACTIVITY(