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 112: SELECT okc_p_util.raw_to_number(sys_guid()) ID

108: ,LAST_UPDATE_DATE
109: ,LAST_UPDATE_LOGIN)
110:
111:
112: SELECT okc_p_util.raw_to_number(sys_guid()) ID
113: ,INNER_Q2.SEQ SEQUENCE_NO
114: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
115: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
116: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

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

328: ,(CASE WHEN SUBS_SCH_DT.INVOICING_RULE_ID = -2 THEN SUBS_SCH_DT.DATE_START
329: WHEN SUBS_SCH_DT.INVOICING_RULE_ID = -3 THEN SUBS_SCH_DT.DATE_END +1
330: END) DATE_TO_INTERFACE
331: FROM
332: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
333: ,INNER_Q2.SEQ SEQUENCE_NUMBER
334:
335: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
336: -- IN OTHER CASES

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

545: ,LAST_UPDATED_BY
546: ,LAST_UPDATE_DATE
547: ,LAST_UPDATE_LOGIN)
548:
549: SELECT okc_p_util.raw_to_number(sys_guid()) ID
550: ,INNER_Q2.SEQ SEQUENCE_NO
551: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
552: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
553: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

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

759: WHEN COV_SCH_DT.INVOICING_RULE_ID = -3 THEN COV_SCH_DT.DATE_END +1
760: END) DATE_TO_INTERFACE
761:
762: FROM
763: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
764: ,INNER_Q2.SEQ SEQUENCE_NUMBER
765: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.STRM_END_DATE = INNER_Q1.FIRST_BILL_UPTO_DATE -- first bill stream
766: AND INNER_Q1.FIRST_BILL_UPTO_DATE IS NOT NULL
767: THEN INNER_Q1.CVL_START_DT

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

939: ,CREATION_DATE
940: ,LAST_UPDATED_BY
941: ,LAST_UPDATE_DATE
942: ,LAST_UPDATE_LOGIN)
943: SELECT okc_p_util.raw_to_number(sys_guid()) ID
944: ,INNER_Q2.SEQ SEQUENCE_NO
945: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
946: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
947: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

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

1118: ,(CASE WHEN USG_SCH_DT.INVOICING_RULE_ID = -2 THEN USG_SCH_DT.DATE_START
1119: WHEN USG_SCH_DT.INVOICING_RULE_ID = -3 THEN USG_SCH_DT.DATE_END +1
1120: END) DATE_TO_INTERFACE
1121: FROM
1122: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
1123: ,INNER_Q2.SEQ SEQUENCE_NUMBER
1124: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
1125: -- IN OTHER CASES
1126: ELSE DECODE (INNER_Q1.BILLING_INTERVAL_PERIOD

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

1331: ,LAST_UPDATED_BY
1332: ,LAST_UPDATE_DATE
1333: ,LAST_UPDATE_LOGIN)
1334:
1335: SELECT okc_p_util.raw_to_number(sys_guid()) ID
1336: ,INNER_Q2.SEQ SEQUENCE_NO
1337: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'
1338: WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD
1339: WHEN INNER_Q2.SEQ = 2 AND INNER_Q1.first_bill_upto_date IS not NULL THEN INNER_Q1.BILLING_INTERVAL_PERIOD

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

1547: WHEN COV_SCH_DT.INVOICING_RULE_ID = -3 THEN COV_SCH_DT.DATE_END +1
1548: END) DATE_TO_INTERFACE
1549:
1550: FROM
1551: (SELECT okc_p_util.raw_to_number(sys_guid()) ID
1552: ,INNER_Q2.SEQ SEQUENCE_NUMBER
1553: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.STRM_END_DATE = INNER_Q1.FIRST_BILL_UPTO_DATE -- first bill stream
1554: AND INNER_Q1.FIRST_BILL_UPTO_DATE IS NOT NULL
1555: THEN INNER_Q1.CVL_START_DT

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

1729: ,LAST_UPDATED_BY
1730: ,LAST_UPDATE_DATE
1731: ,LAST_UPDATE_LOGIN)
1732:
1733: SELECT okc_p_util.raw_to_number(sys_guid()) ID
1734:
1735: ,INNER_Q2.SEQ SEQUENCE_NO
1736:
1737: ,(CASE WHEN INNER_Q2.SEQ = 1 AND INNER_Q1.first_bill_upto_date IS NOT NULL THEN 'DAY'

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

1903: ,DNZ_CHR_ID
1904: ,PARENT_CLE_ID
1905: ,DATE_END)
1906:
1907: SELECT okc_p_util.raw_to_number(sys_guid()) ID
1908: ,SCH_LIN_INSERT . *
1909: FROM
1910: (SELECT DISTINCT COV_LVL_ELEM.PARENT_CLE_ID AS PAR_CLE_ID
1911: ,LIN_SCH_DT.*