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_TL

Line 825: ,OKL_XTL_SELL_INVS_TL

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
829: ,OKC_K_HEADERS_B

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