APPS.OKS_IMPORT_INSERT dependencies on OKS_INT_COVERED_LEVEL_STG_TEMP

Line 188: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL

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

Line 558: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVL

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
562: ,(SELECT SUM(NVL(USG.TAX_AMOUNT,0)) AS USG_TAX_AMT

Line 1570: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG

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
1574: ,(SELECT SUM(USGSTG.SUBTOTAL ) AS SUBTOTAL

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 2240: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG

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
2244: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

Line 2246: FROM OKS_INT_COVERED_LEVEL_STG_TEMP COVSTG

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
2248: WHERE COVSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2249: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)) INNER_Q
2250:

Line 2308: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG

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
2312: ,OKC_K_LINES_B OKCLINB_SUBLINE

Line 2372: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG

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

Line 2498: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG

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