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_K_HEADERS

Line 784: , OKL_K_HEADERS

780: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
781: FROM OKL_TXL_AR_INV_LNS_B
782: , OKL_TXD_AR_LN_DTLS_B
783: , OKL_TRX_AR_INVOICES_B
784: , OKL_K_HEADERS
785: , OKC_K_HEADERS_B
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.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

Line 787: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

783: , OKL_TRX_AR_INVOICES_B
784: , OKL_K_HEADERS
785: , OKC_K_HEADERS_B
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.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

Line 788: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID

784: , OKL_K_HEADERS
785: , OKC_K_HEADERS_B
786: WHERE OKL_TXD_AR_LN_DTLS_B.TIL_ID_DETAILS = OKL_TXL_AR_INV_LNS_B.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

Line 800: , OKL_K_HEADERS

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
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
804: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID

Line 802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

798: FROM OKL_TXL_AR_INV_LNS_B TIL
799: , OKL_TRX_AR_INVOICES_B
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
804: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
805: AND NOT EXISTS (
806: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD

Line 803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID

799: , OKL_TRX_AR_INVOICES_B
800: , OKL_K_HEADERS
801: , OKC_K_HEADERS_B
802: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
803: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID
804: AND TIL.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
805: AND NOT EXISTS (
806: SELECT 1 FROM OKL_TXD_AR_LN_DTLS_B TXD
807: WHERE TXD.TIL_ID_DETAILS = TIL.ID

Line 846: , OKL_K_HEADERS

842: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
843: FROM OKL_CNSLD_AR_STRMS_B
844: , OKL_CNSLD_AR_LINES_B
845: , OKL_CNSLD_AR_HDRS_B
846: , OKL_K_HEADERS
847: , OKC_K_HEADERS_B
848: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
849: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

Line 850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

846: , OKL_K_HEADERS
847: , OKC_K_HEADERS_B
848: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
849: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
851: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
852: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
853: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
854:

Line 851: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

847: , OKC_K_HEADERS_B
848: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
849: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
850: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
851: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
852: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
853: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
854:
855: -- This cursor is used for the following purpose

Line 862: , OKL_K_HEADERS

858: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
859: FROM OKL_CNSLD_AR_STRMS_B
860: , OKL_CNSLD_AR_LINES_B
861: , OKL_CNSLD_AR_HDRS_B
862: , OKL_K_HEADERS
863: , OKC_K_HEADERS_B
864: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
865: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

Line 866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

862: , OKL_K_HEADERS
863: , OKC_K_HEADERS_B
864: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
865: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
867: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
868: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
869: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
870: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;

Line 867: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

863: , OKC_K_HEADERS_B
864: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
865: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
866: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
867: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
868: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
869: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
870: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;
871: