APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_TXD_AR_LN_DTLS_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 782: , OKL_TXD_AR_LN_DTLS_B

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
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

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

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
794: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

Line 806: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD

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
807: WHERE TXD.TIL_ID_DETAILS = TIL.ID
808: )
809: AND TIL.ID NOT IN
810: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID

Line 828: ,OKL_TXD_AR_LN_DTLS_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
832: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL

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