APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 776: -- For every record in okl_trx_ar_invoices_b, okl_txl_ar_inv_lns_b, okl_txd_ar_ln_dtls_b

772: is_debug_statement_on BOOLEAN;
773: l_contract VARCHAR2(120);
774:
775: -- This cursor is used for the following purpose
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

Line 781: FROM OKL_TXL_AR_INV_LNS_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
785: , OKC_K_HEADERS_B

Line 786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

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
790: AND OKL_TXD_AR_LN_DTLS_B.ID NOT IN

Line 789: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

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
792: FROM OKL_XTL_SELL_INVS_B
793: , OKL_EXT_SELL_INVS_B

Line 798: FROM OKL_TXL_AR_INV_LNS_B TIL

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
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

Line 827: ,OKL_TXL_AR_INV_LNS_B

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
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

Line 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)

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)
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:

Line 834: AND OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

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)
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

Line 835: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

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)
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