[Home] [Help]
760: WHERE id = p_khr_id;
761:
762: CURSOR sty_id_csr(p_sty_id NUMBER) IS
763: SELECT name
764: FROM okl_strm_type_v
765: WHERE id = p_sty_id;
766:
767: CURSOR rcpt_method_csr(p_rct_method_id NUMBER) IS
768: SELECT c.creation_method_code
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
779: CURSOR l_curr_csr(cp_currency_code VARCHAR2) IS
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
3290: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
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
3339: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
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'
3390: AND t1.khr_id = CHR.id
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'
3445: AND t1.khr_id = CHR.id