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_COVERED_LEVELS_INTERFACE

Line 192: FROM OKS_COVERED_LEVELS_INTERFACE COV

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
193: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL
194: WHERE CVL.COVERED_LEVEL_INTERFACE_ID= COV.COVERED_LEVEL_INTERFACE_ID
195: AND COV.STATUS_CODE <>'CANCELLED'
196: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL

Line 562: FROM OKS_COVERED_LEVELS_INTERFACE COV

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
564: WHERE CVL.COVERED_LEVEL_INTERFACE_ID= COV.COVERED_LEVEL_INTERFACE_ID
565: AND COV.STATUS_CODE <>'CANCELLED'
566: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL

Line 1574: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT

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
1574: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT
1575: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1576: WHERE CVLINT.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID
1577: AND cvlint.status_code <>'CANCELLED'
1578: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL

Line 1881: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG

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
1881: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1882: WHERE CVLINT.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID
1883: AND CVLINT.STATUS_CODE <>'CANCELLED'
1884: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1885: ,(SELECT SUM(USGSTG.TAX_AMOUNT) AS TAX_AMOUNT

Line 2249: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2245: - ADD_MONTHS(OKSLINSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
2246: / (INNER_Q.NYEARS+1) /(OKSLINSTG.END_DATE - OKSLINSTG.START_DATE+ 1) ANNUALIZED_FACTOR
2247: ,'Y' PRICE_LEVEL_IND -- defaulted
2248:
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

Line 2317: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2313: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2314: ,SYSDATE LAST_UPDATE_DATE
2315: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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

Line 2381: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2377: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2378: ,SYSDATE LAST_UPDATE_DATE
2379: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2380:
2381: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2382: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2383: ,OKC_K_HEADERS_aLL_B OKCHDRB
2384: ,OKC_K_LINES_B OKCLINB_LINE
2385: ,OKC_K_LINES_B OKCLINB_SUBLINE

Line 2507: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2503: ,USERENV('LANG') SOURCE_LANG
2504: ,'N' OKC_SFWT_FLAG
2505: ,OCLI.LINE_REFERENCE LINE_REFERENCE
2506:
2507: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2508: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2509: ,OKC_K_HEADERS_aLL_B OKCHDRB
2510: ,OKC_K_LINES_B OKCLINB_LINE
2511: ,OKC_K_LINES_B OKCLINB_SUBLINE