eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_XTL_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 791: ( SELECT OKL_XTL_SELL_INVS_B.TLD_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
795: AND OKL_XTL_SELL_INVS_B.TLD_ID IS NOT NULL)

Line 792: FROM OKL_XTL_SELL_INVS_B

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

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 795: AND OKL_XTL_SELL_INVS_B.TLD_ID IS NOT NULL)

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
799: , OKL_TRX_AR_INVOICES_B

Line 810: (SELECT OKL_XTL_SELL_INVS_B.TIL_ID

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

Line 811: FROM OKL_XTL_SELL_INVS_B

807: WHERE TXD.TIL_ID_DETAILS = TIL.ID
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:

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 814: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);

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
818: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,

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

819: -- okl_cnsld_ar_Strms_b tables.
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

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

Line 831: AND OKL_XTL_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_TL.ID

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
835: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

Line 832: AND OKL_XTL_SELL_INVS_B.LSM_ID IS NULL

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

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: