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 978: ,OKL_XTL_SELL_INVS_TL

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

Line 984: AND OKL_XTL_SELL_INVS_B.ID = OKL_XTL_SELL_INVS_TL.ID

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