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.OKS_IMPORT_POST_INSERT dependencies on OKC_P_UTIL

Line 119: SELECT okc_p_util.raw_to_number(sys_guid()) ID

115: ,LAST_UPDATE_DATE
116: ,LAST_UPDATE_LOGIN)
117:
118:
119: SELECT okc_p_util.raw_to_number(sys_guid()) ID
120: ,INNER_Q2.SEQ SEQUENCE_NO
121: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
122: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
123: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

Line 358: (SELECT okc_p_util.raw_to_number(sys_guid()) ID

354: ,(CASE WHEN SUBS_SCH_DT.INVOICING_RULE_ID = -2 THEN SUBS_SCH_DT.DATE_START
355: WHEN SUBS_SCH_DT.INVOICING_RULE_ID = -3 THEN SUBS_SCH_DT.DATE_END +1
356: END) DATE_TO_INTERFACE
357: FROM
358: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
359: ,INNER_Q2.SEQ SEQUENCE_NUMBER
360:
361: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
362: -- IN OTHER CASES

Line 653: SELECT okc_p_util.raw_to_number(sys_guid()) ID

649: ,LAST_UPDATED_BY
650: ,LAST_UPDATE_DATE
651: ,LAST_UPDATE_LOGIN)
652:
653: SELECT okc_p_util.raw_to_number(sys_guid()) ID
654: ,INNER_Q2.SEQ SEQUENCE_NO
655: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
656: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
657: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

Line 887: (SELECT okc_p_util.raw_to_number(sys_guid()) ID

883: WHEN COV_SCH_DT.INVOICING_RULE_ID = -3 THEN COV_SCH_DT.DATE_END +1
884: END) DATE_TO_INTERFACE
885:
886: FROM
887: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
888: ,INNER_Q2.SEQ SEQUENCE_NUMBER
889: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.STRM_END_DATE = INNER_Q1.FIRST_BILL_UPTO_DATE -- first bill stream
890: AND INNER_Q1.FIRST_BILL_UPTO_DATE IS NOT NULL
891: THEN INNER_Q1.CVL_START_DT

Line 1121: SELECT okc_p_util.raw_to_number(sys_guid()) ID

1117: ,CREATION_DATE
1118: ,LAST_UPDATED_BY
1119: ,LAST_UPDATE_DATE
1120: ,LAST_UPDATE_LOGIN)
1121: SELECT okc_p_util.raw_to_number(sys_guid()) ID
1122: ,INNER_Q2.SEQ SEQUENCE_NO
1123: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
1124: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
1125: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

Line 1319: (SELECT okc_p_util.raw_to_number(sys_guid()) ID

1315: ,(CASE WHEN USG_SCH_DT.INVOICING_RULE_ID = -2 THEN USG_SCH_DT.DATE_START
1316: WHEN USG_SCH_DT.INVOICING_RULE_ID = -3 THEN USG_SCH_DT.DATE_END +1
1317: END) DATE_TO_INTERFACE
1318: FROM
1319: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
1320: ,INNER_Q2.SEQ SEQUENCE_NUMBER
1321: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
1322: -- IN OTHER CASES
1323: ELSE /*DECODE (INNER_Q1.BILLING_INTERVAL_PERIOD

Line 1585: SELECT okc_p_util.raw_to_number(sys_guid()) ID

1581: ,LAST_UPDATED_BY
1582: ,LAST_UPDATE_DATE
1583: ,LAST_UPDATE_LOGIN)
1584:
1585: SELECT okc_p_util.raw_to_number(sys_guid()) ID
1586: ,INNER_Q2.SEQ SEQUENCE_NO
1587: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
1588: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
1589: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

Line 1821: (SELECT okc_p_util.raw_to_number(sys_guid()) ID

1817: WHEN COV_SCH_DT.INVOICING_RULE_ID = -3 THEN COV_SCH_DT.DATE_END +1
1818: END) DATE_TO_INTERFACE
1819:
1820: FROM
1821: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
1822: ,INNER_Q2.SEQ SEQUENCE_NUMBER
1823: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.STRM_END_DATE = INNER_Q1.FIRST_BILL_UPTO_DATE -- first bill stream
1824: AND INNER_Q1.FIRST_BILL_UPTO_DATE IS NOT NULL
1825: THEN INNER_Q1.CVL_START_DT

Line 2057: SELECT okc_p_util.raw_to_number(sys_guid()) ID

2053: ,LAST_UPDATED_BY
2054: ,LAST_UPDATE_DATE
2055: ,LAST_UPDATE_LOGIN)
2056:
2057: SELECT okc_p_util.raw_to_number(sys_guid()) ID
2058:
2059: ,INNER_Q2.SEQ SEQUENCE_NO
2060:
2061: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'

Line 2251: SELECT okc_p_util.raw_to_number(sys_guid()) ID

2247: ,DNZ_CHR_ID
2248: ,PARENT_CLE_ID
2249: ,DATE_END)
2250:
2251: SELECT okc_p_util.raw_to_number(sys_guid()) ID
2252: ,SCH_LIN_INSERT . *
2253: FROM
2254: (SELECT DISTINCT COV_LVL_ELEM.PARENT_CLE_ID AS PAR_CLE_ID
2255: ,LIN_SCH_DT.*