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 177: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

173: ,'S' BUY_OR_SELL
174: ,'I' ISSUE_OR_RECEIVE
175: ,NVL(INNER_2.TOTAL,0) ESTIMATED_AMOUNT
176:
177: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
178: ,(SELECT INNER_1.HEADER_INTERFACE_ID
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

Line 182: FROM OKS_INT_HEADER_STG_TEMP HDR

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

Line 343: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

339: ,SYSDATE CREATION_DATE
340: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
341: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
342: ,SYSDATE LAST_UPDATE_DATE
343: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
344: ,OKC_K_HEADERS_ALL_B OKCHDRB
345: WHERE HDRSTG.INTERFACE_STATUS ='S'
346: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
347: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 545: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

541: ,HDRSTG.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
542: ,NVL(INNER_2.TAX_AMOUNT ,0) TAX_AMOUNT
543: ,'T' BILLING_SCHEDULE_TYPE
544:
545: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
546: ,OKC_K_HEADERS_ALL_B OKCHDRB
547: ,(SELECT INNER_1.HEADER_INTERFACE_ID
548: ,SUM(TAX_AMOUNT) TAX_AMOUNT
549: FROM

Line 553: FROM OKS_INT_HEADER_STG_TEMP HDR

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

Line 669: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
666: ,SYSDATE LAST_UPDATE_DATE
667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
668:
669: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
670: ,OKC_K_HEADERS_ALL_B OKCHDRB
671: WHERE HDRSTG.INTERFACE_STATUS ='S'
672: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
673: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 833: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

829: ,SYSDATE CREATION_DATE
830: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
831: ,SYSDATE LAST_UPDATE_DATE
832:
833: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
834: ,OKC_K_HEADERS_ALL_B OKCHDRB
835:
836: WHERE HDRSTG.INTERFACE_STATUS ='S'
837: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 901: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

897: ,USERENV('LANG') SOURCE_LANG
898: ,'N' SFWT_FLAG
899: ,null COGNOMEN
900: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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

Line 961: ,OKS_INT_HEADER_STG_TEMP HDRSTG

957: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
958:
959: FROM OKC_K_PARTY_ROLES_B OKCPTY
960: ,OKC_K_HEADERS_ALL_B OKCHDRB
961: ,OKS_INT_HEADER_STG_TEMP HDRSTG
962:
963: WHERE HDRSTG.INTERFACE_STATUS ='S'
964: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
965: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1053: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

1049: ,FND_GLOBAL.USER_ID CREATED_BY
1050: ,SYSDATE CREATION_DATE
1051: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1052: ,SYSDATE LAST_UPDATE_DATE
1053: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1054: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1055: ,OKC_K_HEADERS_ALL_B OKCHDRB
1056: WHERE HDRSTG.INTERFACE_STATUS='S'
1057: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1112: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

1108: ,FND_GLOBAL.USER_ID CREATED_BY
1109: ,SYSDATE CREATION_DATE
1110: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1111: ,SYSDATE LAST_UPDATE_DATE
1112: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1113: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1114: ,OKC_K_HEADERS_ALL_B OKCHDRB
1115: WHERE HDRSTG.INTERFACE_STATUS='S'
1116: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1209: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 1317: ,OKS_INT_HEADER_STG_TEMP HDRSTG

1313: ,SYSDATE LAST_UPDATE_DATE
1314: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1315:
1316: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1317: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1318: ,OKC_K_HEADERS_ALL_B OKCHDRB
1319:
1320: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1321: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1373: ,OKS_INT_HEADER_STG_TEMP HDRSTG

1369: ,SYSDATE LAST_UPDATE_DATE
1370: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1371:
1372: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1373: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1374: ,OKC_K_HEADERS_ALL_B OKCHDRB
1375: ,OKC_K_LINES_B OKCLINB
1376:
1377: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID

Line 1559: ,OKS_INT_HEADER_STG_TEMP OHSTG

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

Line 1695: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 1868: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 1945: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2019: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2243: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2310: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2378: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2504: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2618: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2726: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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

Line 2853: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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