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_HEADER_STG_TEMP

Line 182: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

178: ,'S' BUY_OR_SELL
179: ,'I' ISSUE_OR_RECEIVE
180: ,NVL(INNER_2.TOTAL,0) ESTIMATED_AMOUNT
181:
182: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
183: ,(SELECT INNER_1.HEADER_INTERFACE_ID
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

Line 187: FROM OKS_INT_HEADER_STG_TEMP HDR

183: ,(SELECT INNER_1.HEADER_INTERFACE_ID
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

Line 348: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

344: ,SYSDATE CREATION_DATE
345: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
346: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
347: ,SYSDATE LAST_UPDATE_DATE
348: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
349: ,OKC_K_HEADERS_ALL_B OKCHDRB
350: WHERE HDRSTG.INTERFACE_STATUS ='S'
351: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
352: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 550: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

546: ,HDRSTG.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
547: ,NVL(INNER_2.TAX_AMOUNT ,0) TAX_AMOUNT
548: ,'T' BILLING_SCHEDULE_TYPE
549:
550: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
551: ,OKC_K_HEADERS_ALL_B OKCHDRB
552: ,(SELECT INNER_1.HEADER_INTERFACE_ID
553: ,SUM(TAX_AMOUNT) TAX_AMOUNT
554: FROM

Line 558: FROM OKS_INT_HEADER_STG_TEMP HDR

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

Line 674: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
671: ,SYSDATE LAST_UPDATE_DATE
672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
673:
674: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
675: ,OKC_K_HEADERS_ALL_B OKCHDRB
676: WHERE HDRSTG.INTERFACE_STATUS ='S'
677: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
678: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 838: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

834: ,SYSDATE CREATION_DATE
835: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
836: ,SYSDATE LAST_UPDATE_DATE
837:
838: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
839: ,OKC_K_HEADERS_ALL_B OKCHDRB
840:
841: WHERE HDRSTG.INTERFACE_STATUS ='S'
842: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 906: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

902: ,USERENV('LANG') SOURCE_LANG
903: ,'N' SFWT_FLAG
904: ,null COGNOMEN
905: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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

Line 966: ,OKS_INT_HEADER_STG_TEMP HDRSTG

962: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
963:
964: FROM OKC_K_PARTY_ROLES_B OKCPTY
965: ,OKC_K_HEADERS_ALL_B OKCHDRB
966: ,OKS_INT_HEADER_STG_TEMP HDRSTG
967:
968: WHERE HDRSTG.INTERFACE_STATUS ='S'
969: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
970: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1058: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

1054: ,FND_GLOBAL.USER_ID CREATED_BY
1055: ,SYSDATE CREATION_DATE
1056: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1057: ,SYSDATE LAST_UPDATE_DATE
1058: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1059: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1060: ,OKC_K_HEADERS_ALL_B OKCHDRB
1061: WHERE HDRSTG.INTERFACE_STATUS='S'
1062: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1117: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

1113: ,FND_GLOBAL.USER_ID CREATED_BY
1114: ,SYSDATE CREATION_DATE
1115: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1116: ,SYSDATE LAST_UPDATE_DATE
1117: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1118: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1119: ,OKC_K_HEADERS_ALL_B OKCHDRB
1120: WHERE HDRSTG.INTERFACE_STATUS='S'
1121: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1214: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 1322: ,OKS_INT_HEADER_STG_TEMP HDRSTG

1318: ,SYSDATE LAST_UPDATE_DATE
1319: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1320:
1321: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1322: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1323: ,OKC_K_HEADERS_ALL_B OKCHDRB
1324:
1325: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1326: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1378: ,OKS_INT_HEADER_STG_TEMP HDRSTG

1374: ,SYSDATE LAST_UPDATE_DATE
1375: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1376:
1377: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1378: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1379: ,OKC_K_HEADERS_ALL_B OKCHDRB
1380: ,OKC_K_LINES_B OKCLINB
1381:
1382: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID

Line 1564: ,OKS_INT_HEADER_STG_TEMP OHSTG

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
1568: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, LINE_INTERFACE_ID

Line 1703: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
1707: AND HDRSTG.CONTRACT_NUMBER= OKCHDRB.CONTRACT_NUMBER

Line 1876: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
1880: ,CVLSTG.LINE_INTERFACE_ID

Line 1953: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2027: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2031: AND HDRSTG.INTERFACE_STATUS ='S'

Line 2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2089: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2253: ,OKS_INT_HEADER_STG_TEMP HDRSTG

2249: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
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

Line 2320: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2388: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2392: AND OKSLINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2514: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2518: AND OKSLINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2628: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2632: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

Line 2736: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2740: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID

Line 2863: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2867: ,OKS_K_LINES_B OKSLINB