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 937: , OKL_K_HEADERS

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
940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID

Line 940: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

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
944: ( SELECT OKL_XTL_SELL_INVS_B.TLD_ID

Line 941: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID

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
944: ( SELECT OKL_XTL_SELL_INVS_B.TLD_ID
945: FROM OKL_XTL_SELL_INVS_B

Line 953: , OKL_K_HEADERS

949: UNION
950: SELECT OKC_K_HEADERS_B.CONTRACT_NUMBER
951: FROM OKL_TXL_AR_INV_LNS_B TIL
952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B
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

Line 955: WHERE OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

951: FROM OKL_TXL_AR_INV_LNS_B TIL
952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B
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

Line 956: AND OKL_K_HEADERS.ID = OKL_TRX_AR_INVOICES_B.KHR_ID

952: , OKL_TRX_AR_INVOICES_B
953: , OKL_K_HEADERS
954: , OKC_K_HEADERS_B
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

Line 999: , OKL_K_HEADERS

995: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
996: FROM OKL_CNSLD_AR_STRMS_B
997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

Line 1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1005: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1006: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
1007:

Line 1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1005: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1006: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;
1007:
1008: -- This cursor is used for the following purpose

Line 1015: , OKL_K_HEADERS

1011: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
1012: FROM OKL_CNSLD_AR_STRMS_B
1013: , OKL_CNSLD_AR_LINES_B
1014: , OKL_CNSLD_AR_HDRS_B
1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

Line 1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID

1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1021: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1022: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
1023: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;

Line 1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID

1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1021: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID
1022: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0
1023: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;
1024: