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 780: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER

776: -- For every record in okl_trx_ar_invoices_b, okl_txl_ar_inv_lns_b, okl_txd_ar_ln_dtls_b
777: -- check if corresponding records exist in okl_ext_sell_invs_b, okl_xtl_sell_invs_b table.
778: -- We check both two level and three level transactions with the external tables.
779: CURSOR int_ext_check_csr IS
780: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
781: FROM OKL_TXL_AR_INV_LNS_B
782: , OKL_TXD_AR_LN_DTLS_B
783: , OKL_TRX_AR_INVOICES_B
784: , OKL_K_HEADERS

Line 785: , OKC_K_HEADERS_B

781: FROM OKL_TXL_AR_INV_LNS_B
782: , OKL_TXD_AR_LN_DTLS_B
783: , OKL_TRX_AR_INVOICES_B
784: , OKL_K_HEADERS
785: , OKC_K_HEADERS_B
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
787: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
788: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
789: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

Line 787: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

783: , OKL_TRX_AR_INVOICES_B
784: , OKL_K_HEADERS
785: , OKC_K_HEADERS_B
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
787: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
788: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
789: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
790: AND OKL_TXD_AR_LN_DTLS_B.ID NOT IN
791: ( SELECT OKL_XTL_SELL_INVS_B.TLD_ID

Line 797: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER

793: , OKL_EXT_SELL_INVS_B
794: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
795: AND OKL_XTL_SELL_INVS_B.TLD_ID IS NOT NULL)
796: UNION
797: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
798: FROM OKL_TXL_AR_INV_LNS_B TIL
799: , OKL_TRX_AR_INVOICES_B
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B

Line 801: , OKC_K_HEADERS_B

797: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
798: FROM OKL_TXL_AR_INV_LNS_B TIL
799: , OKL_TRX_AR_INVOICES_B
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
804: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
805: AND NOT EXISTS (

Line 802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

798: FROM OKL_TXL_AR_INV_LNS_B TIL
799: , OKL_TRX_AR_INVOICES_B
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
804: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
805: AND NOT EXISTS (
806: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD

Line 822: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

818: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,
819: -- okl_cnsld_ar_Strms_b tables.
820:
821: CURSOR ext_cnsld_check_csr IS
822: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
823: FROM OKL_XTL_SELL_INVS_B
824: ,OKL_EXT_SELL_INVS_B
825: ,OKL_XTL_SELL_INVS_TL
826: ,OKL_TRX_AR_INVOICES_B

Line 829: ,OKC_K_HEADERS_B

825: ,OKL_XTL_SELL_INVS_TL
826: ,OKL_TRX_AR_INVOICES_B
827: ,OKL_TXL_AR_INV_LNS_B
828: ,OKL_TXD_AR_LN_DTLS_B
829: ,OKC_K_HEADERS_B
830: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
831: AND OKL_XTL_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_TL.ID
832: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL
833: 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 836: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;

832: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL
833: 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)
834: AND OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
835: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
836: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;
837:
838: -- This cursor is used for the following purpose
839: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check
840: -- if corresponding records exist in AR.

Line 842: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

838: -- This cursor is used for the following purpose
839: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check
840: -- if corresponding records exist in AR.
841: CURSOR cnsld_ar_check_csr IS
842: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
843: FROM OKL_CNSLD_AR_STRMS_B
844: , OKL_CNSLD_AR_LINES_B
845: , OKL_CNSLD_AR_HDRS_B
846: , OKL_K_HEADERS

Line 847: , OKC_K_HEADERS_B

843: FROM OKL_CNSLD_AR_STRMS_B
844: , OKL_CNSLD_AR_LINES_B
845: , OKL_CNSLD_AR_HDRS_B
846: , OKL_K_HEADERS
847: , OKC_K_HEADERS_B
848: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
849: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
851: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

Line 850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

846: , OKL_K_HEADERS
847: , OKC_K_HEADERS_B
848: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
849: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
851: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
852: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
853: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
854:

Line 858: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

854:
855: -- This cursor is used for the following purpose
856: -- For every record in okl_cnsld_ar_strms_b check if receivable_invoice_id is a positive number.
857: CURSOR cnsld_pstv_check_csr IS
858: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
859: FROM OKL_CNSLD_AR_STRMS_B
860: , OKL_CNSLD_AR_LINES_B
861: , OKL_CNSLD_AR_HDRS_B
862: , OKL_K_HEADERS

Line 863: , OKC_K_HEADERS_B

859: FROM OKL_CNSLD_AR_STRMS_B
860: , OKL_CNSLD_AR_LINES_B
861: , OKL_CNSLD_AR_HDRS_B
862: , OKL_K_HEADERS
863: , OKC_K_HEADERS_B
864: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
865: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
867: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

Line 866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

862: , OKL_K_HEADERS
863: , OKC_K_HEADERS_B
864: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
865: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
867: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
868: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
869: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
870: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;