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_CNSLD_AR_LINES_B

Line 971: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,

967: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
968:
969: -- This cursor is used for the following purpose
970: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if
971: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,
972: -- okl_cnsld_ar_Strms_b tables.
973:
974: CURSOR ext_cnsld_check_csr IS
975: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

Line 992: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check

988: AND OKL_TXL_AR_INV_LNS_B.TAI_ID = OKL_TRX_AR_INVOICES_B.ID
989: AND OKL_TRX_AR_INVOICES_B.KHR_ID = OKC_K_HEADERS_B.id;
990:
991: -- This cursor is used for the following purpose
992: -- For every record in okl_cnsld_hdrs_b, okl_cnsld_ar_lines_b, okl_cnsld_ar_strms_b check
993: -- if corresponding records exist in AR.
994: CURSOR cnsld_ar_check_csr IS
995: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
996: FROM OKL_CNSLD_AR_STRMS_B

Line 997: , OKL_CNSLD_AR_LINES_B

993: -- if corresponding records exist in AR.
994: CURSOR cnsld_ar_check_csr IS
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

Line 1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID

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

Line 1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID

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

Line 1005: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID

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
1009: -- For every record in okl_cnsld_ar_strms_b check if receivable_invoice_id is a positive number.

Line 1013: , OKL_CNSLD_AR_LINES_B

1009: -- For every record in okl_cnsld_ar_strms_b check if receivable_invoice_id is a positive number.
1010: CURSOR cnsld_pstv_check_csr IS
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

Line 1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID

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

Line 1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID

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

Line 1021: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID

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:
1025: BEGIN