APPS.OKL_CONS_BILL dependencies on OKC_K_HEADERS_B

Line 1018: FROM OKC_K_HEADERS_B CHR,

1014: WHERE id = p_cle_id;
1015:
1016: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1017: SELECT FA.ID
1018: FROM OKC_K_HEADERS_B CHR,
1019: OKC_K_LINES_B TOP_CLE,
1020: OKC_LINE_STYLES_b TOP_LSE,
1021: OKC_K_LINES_B SUB_CLE,
1022: OKC_LINE_STYLES_b SUB_LSE,

Line 1586: okc_k_headers_b chr,

1582: okl_xtl_sell_invs_v xls,
1583: okl_txd_ar_ln_dtls_v tld,
1584: okl_txl_ar_inv_lns_v til,
1585: okl_trx_ar_invoices_v tai,
1586: okc_k_headers_b chr,
1587: okl_parallel_processes pws
1588: WHERE
1589: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND
1590: xls.xsi_id_details = xsi.id AND

Line 1639: okc_k_headers_b chr,

1635: okl_ext_sell_invs_v xsi,
1636: okl_xtl_sell_invs_v xls,
1637: okl_txl_ar_inv_lns_v til,
1638: okl_trx_ar_invoices_v tai,
1639: okc_k_headers_b chr,
1640: okl_parallel_processes pws
1641: WHERE
1642: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND
1643: xls.xsi_id_details = xsi.id AND

Line 1688: okc_k_headers_b chr,

1684: okl_ext_sell_invs_v xsi,
1685: okl_xtl_sell_invs_v xls,
1686: okl_txl_ar_inv_lns_v til,
1687: okl_trx_ar_invoices_v tai,
1688: okc_k_headers_b chr,
1689: okl_parallel_processes pws
1690: WHERE
1691: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND
1692: xls.xsi_id_details = xsi.id AND

Line 1819: okc_k_headers_b chr,

1815: okl_xtl_sell_invs_v xls,
1816: okl_txd_ar_ln_dtls_v tld,
1817: okl_txl_ar_inv_lns_v til,
1818: okl_trx_ar_invoices_v tai,
1819: okc_k_headers_b chr,
1820: okl_parallel_processes pws
1821: WHERE
1822: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND
1823: xls.xsi_id_details = xsi.id AND

Line 1866: okc_k_headers_b chr,

1862: okl_xtl_sell_invs_v xlsr,
1863: okl_txd_ar_ln_dtls_v tld,
1864: okl_txl_ar_inv_lns_v til,
1865: okl_trx_ar_invoices_v tai,
1866: okc_k_headers_b chr,
1867: okl_parallel_processes pws
1868: WHERE
1869: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND
1870: xls.xsi_id_details = xsi.id AND

Line 1922: FROM OKC_K_HEADERS_B CHR,

1918: AND KLE.PARENT_LINE_ID = LSM.KLE_ID;
1919:
1920: CURSOR service_asset_csr (p_lsm_id NUMBER) IS
1921: SELECT FA.NAME
1922: FROM OKC_K_HEADERS_B CHR,
1923: OKC_K_LINES_B TOP_CLE,
1924: OKC_LINE_STYLES_b TOP_LSE,
1925: OKC_K_LINES_B SUB_CLE,
1926: OKC_LINE_STYLES_b SUB_LSE,

Line 2022: FROM okc_k_headers_b

2018: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2019:
2020: CURSOR cntrct_csr ( p_id NUMBER ) IS
2021: SELECT contract_number
2022: FROM okc_k_headers_b
2023: WHERE id = p_id;
2024:
2025: CURSOR strm_csr ( p_id NUMBER ) IS
2026: SELECT name

Line 2030: l_contract_number okc_k_headers_b.contract_number%TYPE;

2026: SELECT name
2027: FROM okl_strm_type_v
2028: WHERE id = p_id;
2029:
2030: l_contract_number okc_k_headers_b.contract_number%TYPE;
2031: l_stream_name1 okl_strm_type_v.name%TYPE;
2032:
2033: l_temp_khr_id NUMBER;
2034:

Line 3018: okc_k_headers_b khr

3014: -- l_xlsv_rec.XTRX_ASSET,
3015: l_xlsv_rec.XTRX_STREAM_GROUP
3016: FROM okl_cnsld_ar_lines_v lln,
3017: okl_invc_line_types_v ilt,
3018: okc_k_headers_b khr
3019: WHERE lln.id = cnr_update_tbl(cnr_tab_idx).lln_id AND
3020: khr.id = lln.khr_id AND
3021: lln.ilt_id = ilt.id(+);
3022: EXCEPTION