APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_EXT_SELL_INVS_B

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

926: l_contract VARCHAR2(120);
927:
928: -- This cursor is used for the following purpose
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

Line 946: , OKL_EXT_SELL_INVS_B

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
945: FROM OKL_XTL_SELL_INVS_B
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

Line 947: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

943: AND OKL_TXD_AR_LN_DTLS_B.ID NOT IN
944: ( SELECT OKL_XTL_SELL_INVS_B.TLD_ID
945: FROM OKL_XTL_SELL_INVS_B
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

Line 965: , OKL_EXT_SELL_INVS_B

961: )
962: AND TIL.ID NOT IN
963: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID
964: FROM OKL_XTL_SELL_INVS_B
965: , OKL_EXT_SELL_INVS_B
966: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
967: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
968:
969: -- This cursor is used for the following purpose

Line 966: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

962: AND TIL.ID NOT IN
963: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID
964: FROM OKL_XTL_SELL_INVS_B
965: , OKL_EXT_SELL_INVS_B
966: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS
967: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
968:
969: -- This cursor is used for the following purpose
970: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if

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

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

Line 977: ,OKL_EXT_SELL_INVS_B

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
980: ,OKL_TXL_AR_INV_LNS_B
981: ,OKL_TXD_AR_LN_DTLS_B

Line 983: WHERE OKL_EXT_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_B.XSI_ID_DETAILS

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