APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKC_K_HEADERS_B

Line 714: FROM okc_k_headers_b

710: */
711:
712: CURSOR org_id_csr(p_khr_id NUMBER) IS
713: SELECT authoring_org_id
714: FROM okc_k_headers_b
715: WHERE id = p_khr_id;
716:
717: /*CURSOR Cur_address_billto(p_id IN VARCHAR2,Code VARCHAR2) IS
718: SELECT A.cust_account_id,

Line 759: FROM okc_k_headers_b

755: and B.TERM_ID = T.TERM_ID;
756:
757: CURSOR cntrct_csr(p_khr_id NUMBER) IS
758: SELECT contract_number
759: FROM okc_k_headers_b
760: WHERE id = p_khr_id;
761:
762: CURSOR sty_id_csr(p_sty_id NUMBER) IS
763: SELECT name

Line 774: l_contract_number okc_k_headers_b.contract_number%TYPE;

770: ar_receipt_classes c
771: WHERE m.receipt_class_id = c.receipt_class_id
772: AND m.receipt_method_id = p_rct_method_id;
773:
774: l_contract_number okc_k_headers_b.contract_number%TYPE;
775: l_stream_name okl_strm_type_v.name%TYPE;
776: l_rct_method_code ar_receipt_classes.creation_method_code%TYPE;
777:
778: -- Get currency attributes

Line 928: FROM okc_k_headers_b

924:
925: -- to get inventory_org_id bug 4890024 begin
926: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
927: SELECT NVL(inv_organization_id, -99)
928: FROM okc_k_headers_b
929: WHERE id = p_contract_id;
930: -- bug 4890024 end
931: --bug 5160519
932: lx_remrkt_sty_id NUMBER;

Line 3287: okc_k_headers_b CHR

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
3290: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
3291: AND t2.tai_id = t1.id

Line 3336: okc_k_headers_b CHR

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
3339: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
3340: AND t2.tai_id = t1.id

Line 3387: okc_k_headers_b CHR,

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'
3390: AND t1.khr_id = CHR.id
3391: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)

Line 3442: okc_k_headers_b CHR,

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'
3445: AND t1.khr_id = CHR.id
3446: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)