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 187: FROM OKS_COVERED_LEVELS_INTERFACE COV

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
188: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL
189: WHERE CVL.COVERED_LEVEL_INTERFACE_ID= COV.COVERED_LEVEL_INTERFACE_ID
190: AND COV.STATUS_CODE <>'CANCELLED'
191: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL

Line 557: FROM OKS_COVERED_LEVELS_INTERFACE COV

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

Line 1569: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT

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
1569: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT
1570: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1571: WHERE CVLINT.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID
1572: AND cvlint.status_code <>'CANCELLED'
1573: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL

Line 1873: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG

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
1873: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1874: WHERE CVLINT.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID
1875: AND CVLINT.STATUS_CODE <>'CANCELLED'
1876: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1877: ,(SELECT SUM(USGSTG.TAX_AMOUNT) AS TAX_AMOUNT

Line 2239: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2235: - ADD_MONTHS(OKSLINSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
2236: / (INNER_Q.NYEARS+1) /(OKSLINSTG.END_DATE - OKSLINSTG.START_DATE+ 1) ANNUALIZED_FACTOR
2237: ,'Y' PRICE_LEVEL_IND -- defaulted
2238:
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

Line 2307: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2303: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2304: ,SYSDATE LAST_UPDATE_DATE
2305: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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

Line 2371: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2367: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2368: ,SYSDATE LAST_UPDATE_DATE
2369: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2370:
2371: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2372: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2373: ,OKC_K_HEADERS_aLL_B OKCHDRB
2374: ,OKC_K_LINES_B OKCLINB_LINE
2375: ,OKC_K_LINES_B OKCLINB_SUBLINE

Line 2497: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

2493: ,USERENV('LANG') SOURCE_LANG
2494: ,'N' OKC_SFWT_FLAG
2495: ,OCLI.LINE_REFERENCE LINE_REFERENCE
2496:
2497: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2498: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2499: ,OKC_K_HEADERS_aLL_B OKCHDRB
2500: ,OKC_K_LINES_B OKCLINB_LINE
2501: ,OKC_K_LINES_B OKCLINB_SUBLINE