APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

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

925: is_debug_statement_on BOOLEAN;
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

Line 935: , OKL_TXD_AR_LN_DTLS_B

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
935: , OKL_TXD_AR_LN_DTLS_B
936: , OKL_TRX_AR_INVOICES_B
937: , OKL_K_HEADERS
938: , OKC_K_HEADERS_B
939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

Line 939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

935: , OKL_TXD_AR_LN_DTLS_B
936: , OKL_TRX_AR_INVOICES_B
937: , OKL_K_HEADERS
938: , OKC_K_HEADERS_B
939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
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

Line 943: AND OKL_TXD_AR_LN_DTLS_B.ID NOT IN

939: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID
940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
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

Line 959: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD

955: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
956: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
957: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
958: AND NOT EXISTS (
959: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD
960: WHERE TXD.TIL_ID_DETAILS = TIL.ID
961: )
962: AND TIL.ID NOT IN
963: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID

Line 981: ,OKL_TXD_AR_LN_DTLS_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
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

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

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
988: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
989: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;
990:

Line 987: AND OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.ID

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
988: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
989: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;
990:
991: -- This cursor is used for the following purpose