APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_EXT_SELL_INVS_B

Line 777: -- check if corresponding records exist in okl_ext_sell_invs_b, okl_xtl_sell_invs_b table.

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
781: FROM OKL_TXL_AR_INV_LNS_B

Line 793: , OKL_EXT_SELL_INVS_B

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
795: AND OKL_XTL_SELL_INVS_B.TLD_ID IS NOT NULL)
796: UNION
797: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER

Line 794: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

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

Line 812: , OKL_EXT_SELL_INVS_B

808: )
809: AND TIL.ID NOT IN
810: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID
811: FROM OKL_XTL_SELL_INVS_B
812: , OKL_EXT_SELL_INVS_B
813: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
814: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
815:
816: -- This cursor is used for the following purpose

Line 813: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

809: AND TIL.ID NOT IN
810: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID
811: FROM OKL_XTL_SELL_INVS_B
812: , OKL_EXT_SELL_INVS_B
813: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
814: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
815:
816: -- This cursor is used for the following purpose
817: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if

Line 817: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if

813: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
814: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
815:
816: -- This cursor is used for the following purpose
817: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if
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

Line 824: ,OKL_EXT_SELL_INVS_B

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
827: ,OKL_TXL_AR_INV_LNS_B
828: ,OKL_TXD_AR_LN_DTLS_B

Line 830: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

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)
834: AND OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID