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_INSERT dependencies on OKS_INT_LINE_STG_TEMP

Line 183: ,OKS_INT_LINE_STG_TEMP LSTG

179: ,SUM(ESTIMATED_AMOUNT) TOTAL
180: FROM ((SELECT HDR.HEADER_INTERFACE_ID
181: ,NVL(SUM(INNER2_CVL.CVL_SUBTOTAL),0) + NVL(SUM(INNER2_USG.USG_SUBTOTAL),0) as ESTIMATED_AMOUNT
182: FROM OKS_INT_HEADER_STG_TEMP HDR
183: ,OKS_INT_LINE_STG_TEMP LSTG
184:
185: ,(SELECT SUM(NVL(COV.SUBTOTAL,0)) AS CVL_SUBTOTAL
186: ,COV.LINE_INTERFACE_ID
187: FROM OKS_COVERED_LEVELS_INTERFACE COV

Line 209: FROM OKS_INT_LINE_STG_TEMP LST

205: UNION
206:
207: (SELECT LST.HEADER_INTERFACE_ID
208: ,SUM(LST.SUBTOTAL) ESTIMATED_AMOUNT
209: FROM OKS_INT_LINE_STG_TEMP LST
210: WHERE LST.LINE_TYPE ='SUBSCRIPTION'
211: AND LST.STATUS_CODE <>'CANCELLED'
212: GROUP BY LST.HEADER_INTERFACE_ID)) INNER_1
213: GROUP BY INNER_1.HEADER_INTERFACE_ID) INNER_2

Line 554: ,OKS_INT_LINE_STG_TEMP LSTG

550: ((SELECT HDR.HEADER_INTERFACE_ID
551: ,NVL(SUM(INNER2_CVL.CVL_TAX_AMT),0) + NVL(SUM(INNER2_USG.USG_TAX_AMT),0) as TAX_AMOUNT
552:
553: FROM OKS_INT_HEADER_STG_TEMP HDR
554: ,OKS_INT_LINE_STG_TEMP LSTG
555: ,(SELECT SUM(NVL(COV.TAX_AMOUNT,0)) AS CVL_TAX_AMT
556: ,COV.LINE_INTERFACE_ID
557: FROM OKS_COVERED_LEVELS_INTERFACE COV
558: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL

Line 575: FROM OKS_INT_LINE_STG_TEMP LST

571: GROUP BY HDR.HEADER_INTERFACE_ID)
572: UNION
573: (SELECT LST.HEADER_INTERFACE_ID
574: ,SUM(LST.TAX_AMOUNT) TAX_AMOUNT
575: FROM OKS_INT_LINE_STG_TEMP LST
576: WHERE LST.LINE_TYPE ='SUBSCRIPTION'
577: AND LST.STATUS_CODE <>'CANCELLED'
578: GROUP BY LST.HEADER_INTERFACE_ID)) INNER_1
579: GROUP BY INNER_1.HEADER_INTERFACE_ID) INNER_2

Line 905: ,OKS_INT_LINE_STG_TEMP LINSTG

901: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
902: ,OKC_K_HEADERS_ALL_B OKCHDRB
903: ,OKC_K_LINES_B OKCLINB
904: ,OKS_LINES_INTERFACE LININT
905: ,OKS_INT_LINE_STG_TEMP LINSTG
906:
907: WHERE HDRSTG.INTERFACE_STATUS ='S'
908: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
909: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1208: FROM OKS_INT_LINE_STG_TEMP LINSTG

1204: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1205: ,SYSDATE LAST_UPDATE_DATE
1206: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1207:
1208: FROM OKS_INT_LINE_STG_TEMP LINSTG
1209: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1210: ,OKC_K_HEADERS_ALL_B OKCHDRB
1211: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1212: ,OKC_K_LINES_B OKCLINB

Line 1558: FROM OKS_INT_LINE_STG_TEMP OLSTG

1554: DECODE(ADD_MONTHS(OLSTG.START_DATE, (INNER_Q.NYEARS+1)*12)
1555: - ADD_MONTHS(OLSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
1556: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
1557:
1558: FROM OKS_INT_LINE_STG_TEMP OLSTG
1559: ,OKS_INT_HEADER_STG_TEMP OHSTG
1560: ,OKC_K_HEADERS_ALL_B OKCHDRB
1561: ,HZ_CUST_SITE_USES_ALL CSTSITE
1562: ,HZ_CUST_ACCT_SITES_ALL CSTACCT

Line 1564: FROM OKS_INT_LINE_STG_TEMP LINSTG

1560: ,OKC_K_HEADERS_ALL_B OKCHDRB
1561: ,HZ_CUST_SITE_USES_ALL CSTSITE
1562: ,HZ_CUST_ACCT_SITES_ALL CSTACCT
1563: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, LINE_INTERFACE_ID
1564: FROM OKS_INT_LINE_STG_TEMP LINSTG
1565: WHERE LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)) INNER_Q
1566:
1567: ,(SELECT SUM(CVLINT.SUBTOTAL) AS SUBTOTAL
1568: ,CVLSTG.LINE_INTERFACE_ID

Line 1694: ,OKS_INT_LINE_STG_TEMP OLSTG

1690: END ) PRICED_ITEM_YN
1691: ,1 OBJECT_VERSION_NUMBER
1692:
1693: FROM OKC_K_LINES_B OKCLINB
1694: ,OKS_INT_LINE_STG_TEMP OLSTG
1695: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1696: ,OKC_K_HEADERS_ALL_B OKCHDRB
1697:
1698: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1867: FROM OKS_INT_LINE_STG_TEMP OLSTG

1863: END ) TAX_AMOUNT
1864: ,COV_IN_QUERY.PM_PROGRAM_ID PM_PROGRAM_ID
1865: ,COV_IN_QUERY.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
1866: ,COV_IN_QUERY.PM_CONF_REQ_YN PM_CONF_REQ_YN
1867: FROM OKS_INT_LINE_STG_TEMP OLSTG
1868: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1869: ,OKC_K_HEADERS_ALL_B OKCHDRB
1870: ,OKC_K_LINES_B OKCLINB
1871: ,(SELECT SUM(CVLINT.TAX_AMOUNT) AS TAX_AMOUNT

Line 1888: , OKS_INT_LINE_STG_TEMP LIN

1884: ,OKSLB.PM_CONF_REQ_YN AS PM_CONF_REQ_YN
1885: ,LIN.LINE_INTERFACE_ID
1886: ,LIN.LINE_NUMBER
1887: FROM OKS_K_LINES_B OKSLB
1888: , OKS_INT_LINE_STG_TEMP LIN
1889: WHERE OKSLB.CLE_ID = LIN.REFERENCE_TEMPLATE_ID) COV_IN_QUERY
1890: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1891: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1892: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1944: FROM OKS_INT_LINE_STG_TEMP OLSTG

1940: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1941: ,SYSDATE LAST_UPDATE_DATE
1942: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1943: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1944: FROM OKS_INT_LINE_STG_TEMP OLSTG
1945: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1946: ,OKC_K_HEADERS_ALL_B OKCHDRB
1947: ,OKS_K_LINES_B OKSLINB
1948: ,OKC_K_LINES_B OKCLINB

Line 2018: ,OKS_INT_LINE_STG_TEMP OLSTG

2014: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2015: ,SYSDATE LAST_UPDATE_DATE
2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2017: FROM OKC_K_LINES_B OKCLINB
2018: ,OKS_INT_LINE_STG_TEMP OLSTG
2019: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2020: ,OKS_SUBSCR_HEADER_B SUB_HDR
2021: ,OKC_K_HEADERS_ALL_B OKCHDRB
2022: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2076: ,OKS_INT_LINE_STG_TEMP OLSTG

2072: ,SYSDATE LAST_UPDATE_DATE
2073: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2074:
2075: FROM OKC_K_LINES_B OKCLINB
2076: ,OKS_INT_LINE_STG_TEMP OLSTG
2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2078: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2079: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2080: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL

Line 2244: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2240: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2241: ,OKC_K_HEADERS_ALL_B OKCHDRB
2242: ,OKC_K_LINES_B OKCLINB
2243: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2244: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2245: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID
2246: FROM OKS_INT_COVERED_LEVEL_STG_TEMP COVSTG
2247: ,OKS_INT_LINE_STG_TEMP LINSTG
2248: WHERE COVSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID

Line 2247: ,OKS_INT_LINE_STG_TEMP LINSTG

2243: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2244: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2245: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID
2246: FROM OKS_INT_COVERED_LEVEL_STG_TEMP COVSTG
2247: ,OKS_INT_LINE_STG_TEMP LINSTG
2248: WHERE COVSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2249: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)) INNER_Q
2250:
2251: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2311: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2307: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2308: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2309: ,OKC_K_HEADERS_ALL_B OKCHDRB
2310: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2311: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2312: ,OKC_K_LINES_B OKCLINB_SUBLINE
2313: ,OKC_K_LINES_B OKCLINB_LINE
2314:
2315: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2373: ,OKC_K_HEADERS_aLL_B OKCHDRB
2374: ,OKC_K_LINES_B OKCLINB_LINE
2375: ,OKC_K_LINES_B OKCLINB_SUBLINE
2376: ,OKS_K_LINES_B OKSLINB
2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2378: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2379:
2380: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2381: AND OCLVLSTG.LINE_INTERFACE_ID = OKSLINSTG.LINE_INTERFACE_ID

Line 2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2499: ,OKC_K_HEADERS_aLL_B OKCHDRB
2500: ,OKC_K_LINES_B OKCLINB_LINE
2501: ,OKC_K_LINES_B OKCLINB_SUBLINE
2502: ,OKS_K_LINES_B OKSLINB
2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2504: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2505:
2506: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2507: AND OCLVLSTG.LINE_INTERFACE_ID = OKSLINSTG.LINE_INTERFACE_ID

Line 2617: ,OKS_INT_LINE_STG_TEMP OLSTG

2613: ,null CANCELLED_AMOUNT
2614:
2615: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2616: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2617: ,OKS_INT_LINE_STG_TEMP OLSTG
2618: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2619: ,OKC_K_HEADERS_ALL_B OKCHDRB
2620: ,OKC_K_LINES_B OKCLINB_LINE
2621: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID

Line 2623: ,OKS_INT_LINE_STG_TEMP LINSTG

2619: ,OKC_K_HEADERS_ALL_B OKCHDRB
2620: ,OKC_K_LINES_B OKCLINB_LINE
2621: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2622: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2623: ,OKS_INT_LINE_STG_TEMP LINSTG
2624: WHERE
2625: USGSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2626: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)
2627: ) INNER_Q

Line 2725: ,OKS_INT_LINE_STG_TEMP OLSTG

2721: ,null ORIG_SYSTEM_REFERENCE1
2722: ,'T' BILLING_SCHEDULE_TYPE
2723: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2724: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2725: ,OKS_INT_LINE_STG_TEMP OLSTG
2726: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2727: ,OKC_K_HEADERS_ALL_B OKCHDRB
2728: ,OKC_K_LINES_B OKCLINB_SUBLINE
2729: ,OKC_K_LINES_B OKCLINB_LINE

Line 2852: ,OKS_INT_LINE_STG_TEMP OLSTG

2848: ,1 OBJECT_VERSION_NUMBER
2849:
2850: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2851: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2852: ,OKS_INT_LINE_STG_TEMP OLSTG
2853: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2854: ,OKC_K_HEADERS_ALL_B OKCHDRB
2855: ,OKC_K_LINES_B OKCLINB_SUBLINE
2856: ,OKC_K_LINES_B OKCLINB_LINE