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_STRMS_B

Line 972: -- okl_cnsld_ar_Strms_b tables.

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
976: FROM OKL_XTL_SELL_INVS_B

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 996: FROM OKL_CNSLD_AR_STRMS_B

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
997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B

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 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 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 1006: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NULL;

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.
1010: CURSOR cnsld_pstv_check_csr IS

Line 1009: -- For every record in okl_cnsld_ar_strms_b check if receivable_invoice_id is a positive number.

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

Line 1012: FROM OKL_CNSLD_AR_STRMS_B

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

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

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

Line 1022: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID < 0

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

Line 1023: AND OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID IS NOT NULL;

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
1026:
1027: x_any_data_exists := false; -- VPANWAR changed for pre upgrade test