eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BILLING_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 50: FROM okc_k_headers_b

46: SELECT 'x'
47: FROM ra_customer_trx_lines_all ractrl
48: WHERE ractrl.customer_trx_id = ractrx.customer_trx_id
49: AND ractrl.interface_line_attribute6 = (SELECT contract_number
50: FROM okc_k_headers_b
51: WHERE ID = p_contract_id)
52: );
53: l_invoice_date DATE;
54: l_api_name VARCHAR2(60) := 'Last Invoice Date';

Line 115: okc_k_headers_b chr

111: CURSOR c_strm_invoice_amt(p_stream_purpose IN VARCHAR2) IS
112: SELECT chr.id,
113: SUM(ractrl.amount_due_original) amount
114: FROM ra_customer_trx_lines_all ractrl,
115: okc_k_headers_b chr
116: WHERE chr.contract_number = ractrl.interface_line_attribute6
117: AND EXISTS(SELECT sty.code
118: FROM OKL_STRM_TYPE_B sty
119: WHERE sty.stream_type_purpose = p_stream_purpose

Line 933: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER

929: -- For every record in okl_trx_ar_invoices_b, okl_txl_ar_inv_lns_b, okl_txd_ar_ln_dtls_b
930: -- check if corresponding records exist in okl_ext_sell_invs_b, okl_xtl_sell_invs_b table.
931: -- We check both two level and three level transactions with the external tables.
932: CURSOR int_ext_check_csr IS
933: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
934: FROM OKL_TXL_AR_INV_LNS_B
935: , OKL_TXD_AR_LN_DTLS_B
936: , OKL_TRX_AR_INVOICES_B
937: , OKL_K_HEADERS

Line 938: , OKC_K_HEADERS_B

934: FROM OKL_TXL_AR_INV_LNS_B
935: , OKL_TXD_AR_LN_DTLS_B
936: , OKL_TRX_AR_INVOICES_B
937: , OKL_K_HEADERS
938: , OKC_K_HEADERS_B
939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
942: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

Line 940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

936: , OKL_TRX_AR_INVOICES_B
937: , OKL_K_HEADERS
938: , OKC_K_HEADERS_B
939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
942: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
943: AND OKL_TXD_AR_LN_DTLS_B.ID NOT IN
944: ( SELECT OKL_XTL_SELL_INVS_B.TLD_ID

Line 950: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER

946: , OKL_EXT_SELL_INVS_B
947: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
948: AND OKL_XTL_SELL_INVS_B.TLD_ID IS NOT NULL)
949: UNION
950: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
951: FROM OKL_TXL_AR_INV_LNS_B TIL
952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B

Line 954: , OKC_K_HEADERS_B

950: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
951: FROM OKL_TXL_AR_INV_LNS_B TIL
952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B
955: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
956: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
957: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
958: AND NOT EXISTS (

Line 955: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

951: FROM OKL_TXL_AR_INV_LNS_B TIL
952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B
955: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
956: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
957: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
958: AND NOT EXISTS (
959: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD

Line 975: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

971: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,
972: -- okl_cnsld_ar_Strms_b tables.
973:
974: CURSOR ext_cnsld_check_csr IS
975: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
976: FROM OKL_XTL_SELL_INVS_B
977: ,OKL_EXT_SELL_INVS_B
978: ,OKL_XTL_SELL_INVS_TL
979: ,OKL_TRX_AR_INVOICES_B

Line 982: ,OKC_K_HEADERS_B

978: ,OKL_XTL_SELL_INVS_TL
979: ,OKL_TRX_AR_INVOICES_B
980: ,OKL_TXL_AR_INV_LNS_B
981: ,OKL_TXD_AR_LN_DTLS_B
982: ,OKC_K_HEADERS_B
983: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
984: AND OKL_XTL_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_TL.ID
985: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL
986: AND (OKL_TXL_AR_INV_LNS_B.ID = OKL_XTL_SELL_INVS_B.TIL_ID OR OKL_XTL_SELL_INVS_B.TLD_ID = OKL_TXD_AR_LN_DTLS_B.ID)

Line 989: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;

985: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL
986: AND (OKL_TXL_AR_INV_LNS_B.ID = OKL_XTL_SELL_INVS_B.TIL_ID OR OKL_XTL_SELL_INVS_B.TLD_ID = OKL_TXD_AR_LN_DTLS_B.ID)
987: AND OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
988: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
989: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;
990:
991: -- This cursor is used for the following purpose
992: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check
993: -- if corresponding records exist in AR.

Line 995: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

991: -- This cursor is used for the following purpose
992: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check
993: -- if corresponding records exist in AR.
994: CURSOR cnsld_ar_check_csr IS
995: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
996: FROM OKL_CNSLD_AR_STRMS_B
997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS

Line 1000: , OKC_K_HEADERS_B

996: FROM OKL_CNSLD_AR_STRMS_B
997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

Line 1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1005: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1006: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
1007:

Line 1011: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

1007:
1008: -- This cursor is used for the following purpose
1009: -- For every record in okl_cnsld_ar_strms_b check if receivable_invoice_id is a positive number.
1010: CURSOR cnsld_pstv_check_csr IS
1011: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
1012: FROM OKL_CNSLD_AR_STRMS_B
1013: , OKL_CNSLD_AR_LINES_B
1014: , OKL_CNSLD_AR_HDRS_B
1015: , OKL_K_HEADERS

Line 1016: , OKC_K_HEADERS_B

1012: FROM OKL_CNSLD_AR_STRMS_B
1013: , OKL_CNSLD_AR_LINES_B
1014: , OKL_CNSLD_AR_HDRS_B
1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

Line 1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1021: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1022: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
1023: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;

Line 1713: from okc_k_headers_b chr,

1709: SELECT SUM(ractrl.amount_due_original) amount
1710: FROM ra_customer_trx_lines_all ractrl
1711: WHERE ractrl.interface_line_attribute6 IN
1712: (select chr.contract_number
1713: from okc_k_headers_b chr,
1714: okc_governances gv,
1715: okc_k_headers_b crchr
1716: where crchr.id = p_cr_contract_id
1717: and crchr.sts_code = 'ACTIVE'

Line 1715: okc_k_headers_b crchr

1711: WHERE ractrl.interface_line_attribute6 IN
1712: (select chr.contract_number
1713: from okc_k_headers_b chr,
1714: okc_governances gv,
1715: okc_k_headers_b crchr
1716: where crchr.id = p_cr_contract_id
1717: and crchr.sts_code = 'ACTIVE'
1718: and crchr.scs_code = 'CREDITLINE_CONTRACT'
1719: and gv.chr_id_referred = crchr.id

Line 1724: from okc_k_headers_b mla_chr,

1720: and gv.dnz_chr_id = chr.id
1721: and chr.scs_code = 'LEASE'
1722: UNION
1723: select chr.contract_number
1724: from okc_k_headers_b mla_chr,
1725: okc_governances mla_g1,
1726: okc_k_headers_b chr
1727: where mla_chr.id = mla_g1.chr_id_referred
1728: and mla_chr.scs_code = 'MASTER_LEASE'

Line 1726: okc_k_headers_b chr

1722: UNION
1723: select chr.contract_number
1724: from okc_k_headers_b mla_chr,
1725: okc_governances mla_g1,
1726: okc_k_headers_b chr
1727: where mla_chr.id = mla_g1.chr_id_referred
1728: and mla_chr.scs_code = 'MASTER_LEASE'
1729: and mla_chr.id IN
1730: (

Line 1732: from okc_k_headers_b cl_chr,

1728: and mla_chr.scs_code = 'MASTER_LEASE'
1729: and mla_chr.id IN
1730: (
1731: select cl_gl.dnz_chr_id
1732: from okc_k_headers_b cl_chr,
1733: okc_governances cl_gl
1734: where cl_chr.id = p_cr_contract_id
1735: and cl_chr.sts_code = 'ACTIVE'
1736: and cl_chr.scs_code = 'CREDITLINE_CONTRACT'