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 188: ,OKS_INT_LINE_STG_TEMP LSTG

184: ,SUM(ESTIMATED_AMOUNT) TOTAL
185: FROM ((SELECT HDR.HEADER_INTERFACE_ID
186: ,NVL(SUM(INNER2_CVL.CVL_SUBTOTAL),0) + NVL(SUM(INNER2_USG.USG_SUBTOTAL),0) as ESTIMATED_AMOUNT
187: FROM OKS_INT_HEADER_STG_TEMP HDR
188: ,OKS_INT_LINE_STG_TEMP LSTG
189:
190: ,(SELECT SUM(NVL(COV.SUBTOTAL,0)) AS CVL_SUBTOTAL
191: ,COV.LINE_INTERFACE_ID
192: FROM OKS_COVERED_LEVELS_INTERFACE COV

Line 214: FROM OKS_INT_LINE_STG_TEMP LST

210: UNION
211:
212: (SELECT LST.HEADER_INTERFACE_ID
213: ,SUM(LST.SUBTOTAL) ESTIMATED_AMOUNT
214: FROM OKS_INT_LINE_STG_TEMP LST
215: WHERE LST.LINE_TYPE ='SUBSCRIPTION'
216: AND LST.STATUS_CODE <>'CANCELLED'
217: GROUP BY LST.HEADER_INTERFACE_ID)) INNER_1
218: GROUP BY INNER_1.HEADER_INTERFACE_ID) INNER_2

Line 559: ,OKS_INT_LINE_STG_TEMP LSTG

555: ((SELECT HDR.HEADER_INTERFACE_ID
556: ,NVL(SUM(INNER2_CVL.CVL_TAX_AMT),0) + NVL(SUM(INNER2_USG.USG_TAX_AMT),0) as TAX_AMOUNT
557:
558: FROM OKS_INT_HEADER_STG_TEMP HDR
559: ,OKS_INT_LINE_STG_TEMP LSTG
560: ,(SELECT SUM(NVL(COV.TAX_AMOUNT,0)) AS CVL_TAX_AMT
561: ,COV.LINE_INTERFACE_ID
562: FROM OKS_COVERED_LEVELS_INTERFACE COV
563: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL

Line 580: FROM OKS_INT_LINE_STG_TEMP LST

576: GROUP BY HDR.HEADER_INTERFACE_ID)
577: UNION
578: (SELECT LST.HEADER_INTERFACE_ID
579: ,SUM(LST.TAX_AMOUNT) TAX_AMOUNT
580: FROM OKS_INT_LINE_STG_TEMP LST
581: WHERE LST.LINE_TYPE ='SUBSCRIPTION'
582: AND LST.STATUS_CODE <>'CANCELLED'
583: GROUP BY LST.HEADER_INTERFACE_ID)) INNER_1
584: GROUP BY INNER_1.HEADER_INTERFACE_ID) INNER_2

Line 910: ,OKS_INT_LINE_STG_TEMP LINSTG

906: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
907: ,OKC_K_HEADERS_ALL_B OKCHDRB
908: ,OKC_K_LINES_B OKCLINB
909: ,OKS_LINES_INTERFACE LININT
910: ,OKS_INT_LINE_STG_TEMP LINSTG
911:
912: WHERE HDRSTG.INTERFACE_STATUS ='S'
913: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
914: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1213: FROM OKS_INT_LINE_STG_TEMP LINSTG

1209: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1210: ,SYSDATE LAST_UPDATE_DATE
1211: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1212:
1213: FROM OKS_INT_LINE_STG_TEMP LINSTG
1214: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1215: ,OKC_K_HEADERS_ALL_B OKCHDRB
1216: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1217: ,OKC_K_LINES_B OKCLINB

Line 1563: FROM OKS_INT_LINE_STG_TEMP OLSTG

1559: DECODE(ADD_MONTHS(OLSTG.START_DATE, (INNER_Q.NYEARS+1)*12)
1560: - ADD_MONTHS(OLSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
1561: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
1562:
1563: FROM OKS_INT_LINE_STG_TEMP OLSTG
1564: ,OKS_INT_HEADER_STG_TEMP OHSTG
1565: ,OKC_K_HEADERS_ALL_B OKCHDRB
1566: ,HZ_CUST_SITE_USES_ALL CSTSITE
1567: ,HZ_CUST_ACCT_SITES_ALL CSTACCT

Line 1569: FROM OKS_INT_LINE_STG_TEMP LINSTG

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

Line 1702: ,OKS_INT_LINE_STG_TEMP OLSTG

1698: END ) PRICED_ITEM_YN
1699: ,1 OBJECT_VERSION_NUMBER
1700:
1701: FROM OKC_K_LINES_B OKCLINB
1702: ,OKS_INT_LINE_STG_TEMP OLSTG
1703: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1704: ,OKC_K_HEADERS_ALL_B OKCHDRB
1705:
1706: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1875: FROM OKS_INT_LINE_STG_TEMP OLSTG

1871: END ) TAX_AMOUNT
1872: ,COV_IN_QUERY.PM_PROGRAM_ID PM_PROGRAM_ID
1873: ,COV_IN_QUERY.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
1874: ,COV_IN_QUERY.PM_CONF_REQ_YN PM_CONF_REQ_YN
1875: FROM OKS_INT_LINE_STG_TEMP OLSTG
1876: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1877: ,OKC_K_HEADERS_ALL_B OKCHDRB
1878: ,OKC_K_LINES_B OKCLINB
1879: ,(SELECT SUM(CVLINT.TAX_AMOUNT) AS TAX_AMOUNT

Line 1896: , OKS_INT_LINE_STG_TEMP LIN

1892: ,OKSLB.PM_CONF_REQ_YN AS PM_CONF_REQ_YN
1893: ,LIN.LINE_INTERFACE_ID
1894: ,LIN.LINE_NUMBER
1895: FROM OKS_K_LINES_B OKSLB
1896: , OKS_INT_LINE_STG_TEMP LIN
1897: WHERE OKSLB.CLE_ID = LIN.REFERENCE_TEMPLATE_ID) COV_IN_QUERY
1898: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1899: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1900: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1952: FROM OKS_INT_LINE_STG_TEMP OLSTG

1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1951: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1952: FROM OKS_INT_LINE_STG_TEMP OLSTG
1953: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1954: ,OKC_K_HEADERS_ALL_B OKCHDRB
1955: ,OKS_K_LINES_B OKSLINB
1956: ,OKC_K_LINES_B OKCLINB

Line 2026: ,OKS_INT_LINE_STG_TEMP OLSTG

2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2023: ,SYSDATE LAST_UPDATE_DATE
2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2025: FROM OKC_K_LINES_B OKCLINB
2026: ,OKS_INT_LINE_STG_TEMP OLSTG
2027: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2028: ,OKS_SUBSCR_HEADER_B SUB_HDR
2029: ,OKC_K_HEADERS_ALL_B OKCHDRB
2030: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2084: ,OKS_INT_LINE_STG_TEMP OLSTG

2080: ,SYSDATE LAST_UPDATE_DATE
2081: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2082:
2083: FROM OKC_K_LINES_B OKCLINB
2084: ,OKS_INT_LINE_STG_TEMP OLSTG
2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2086: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2087: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2088: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL

Line 2254: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2250: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2251: ,OKC_K_HEADERS_ALL_B OKCHDRB
2252: ,OKC_K_LINES_B OKCLINB
2253: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2254: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2255: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID
2256: FROM OKS_INT_COVERED_LEVEL_STG_TEMP COVSTG
2257: ,OKS_INT_LINE_STG_TEMP LINSTG
2258: WHERE COVSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID

Line 2257: ,OKS_INT_LINE_STG_TEMP LINSTG

2253: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2254: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2255: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID
2256: FROM OKS_INT_COVERED_LEVEL_STG_TEMP COVSTG
2257: ,OKS_INT_LINE_STG_TEMP LINSTG
2258: WHERE COVSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2259: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)) INNER_Q
2260:
2261: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2321: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2317: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2318: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2319: ,OKC_K_HEADERS_ALL_B OKCHDRB
2320: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2321: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2322: ,OKC_K_LINES_B OKCLINB_SUBLINE
2323: ,OKC_K_LINES_B OKCLINB_LINE
2324:
2325: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID

Line 2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2383: ,OKC_K_HEADERS_aLL_B OKCHDRB
2384: ,OKC_K_LINES_B OKCLINB_LINE
2385: ,OKC_K_LINES_B OKCLINB_SUBLINE
2386: ,OKS_K_LINES_B OKSLINB
2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2388: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2389:
2390: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2391: AND OCLVLSTG.LINE_INTERFACE_ID = OKSLINSTG.LINE_INTERFACE_ID

Line 2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

2509: ,OKC_K_HEADERS_aLL_B OKCHDRB
2510: ,OKC_K_LINES_B OKCLINB_LINE
2511: ,OKC_K_LINES_B OKCLINB_SUBLINE
2512: ,OKS_K_LINES_B OKSLINB
2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2514: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2515:
2516: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2517: AND OCLVLSTG.LINE_INTERFACE_ID = OKSLINSTG.LINE_INTERFACE_ID

Line 2627: ,OKS_INT_LINE_STG_TEMP OLSTG

2623: ,null CANCELLED_AMOUNT
2624:
2625: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2626: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2627: ,OKS_INT_LINE_STG_TEMP OLSTG
2628: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2629: ,OKC_K_HEADERS_ALL_B OKCHDRB
2630: ,OKC_K_LINES_B OKCLINB_LINE
2631: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID

Line 2633: ,OKS_INT_LINE_STG_TEMP LINSTG

2629: ,OKC_K_HEADERS_ALL_B OKCHDRB
2630: ,OKC_K_LINES_B OKCLINB_LINE
2631: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2632: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2633: ,OKS_INT_LINE_STG_TEMP LINSTG
2634: WHERE
2635: USGSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2636: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)
2637: ) INNER_Q

Line 2735: ,OKS_INT_LINE_STG_TEMP OLSTG

2731: ,null ORIG_SYSTEM_REFERENCE1
2732: ,'T' BILLING_SCHEDULE_TYPE
2733: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2734: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2735: ,OKS_INT_LINE_STG_TEMP OLSTG
2736: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2737: ,OKC_K_HEADERS_ALL_B OKCHDRB
2738: ,OKC_K_LINES_B OKCLINB_SUBLINE
2739: ,OKC_K_LINES_B OKCLINB_LINE

Line 2862: ,OKS_INT_LINE_STG_TEMP OLSTG

2858: ,1 OBJECT_VERSION_NUMBER
2859:
2860: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2861: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2862: ,OKS_INT_LINE_STG_TEMP OLSTG
2863: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2864: ,OKC_K_HEADERS_ALL_B OKCHDRB
2865: ,OKC_K_LINES_B OKCLINB_SUBLINE
2866: ,OKC_K_LINES_B OKCLINB_LINE