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 OKC_K_LINES_B

Line 908: ,OKC_K_LINES_B OKCLINB

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
911:
912: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 1217: ,OKC_K_LINES_B OKCLINB

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:
1219: WHERE HDRSTG.INTERFACE_STATUS='S'
1220: AND LINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1221: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1380: ,OKC_K_LINES_B OKCLINB

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
1383: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1384: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1439: INTO OKC_K_LINES_B

1435: l_stmt_num := 10;
1436:
1437: INSERT ALL
1438: WHEN (1=1) THEN
1439: INTO OKC_K_LINES_B
1440: (ID
1441: ,LINE_NUMBER
1442: ,CHR_ID
1443: ,CLE_ID

Line 1701: FROM OKC_K_LINES_B OKCLINB

1697: ELSE 'Y'
1698: END ) PRICED_ITEM_YN
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:

Line 1878: ,OKC_K_LINES_B OKCLINB

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

Line 1956: ,OKC_K_LINES_B OKCLINB

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:
1958: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1959: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1960: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2025: FROM OKC_K_LINES_B OKCLINB

2021: ,SYSDATE CREATION_DATE
2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
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

Line 2083: FROM OKC_K_LINES_B OKCLINB

2079: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2080: ,SYSDATE LAST_UPDATE_DATE
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

Line 2153: INTO OKC_K_LINES_B

2149: l_stmt_num := 10;
2150:
2151: INSERT ALL
2152: WHEN (1=1) THEN
2153: INTO OKC_K_LINES_B
2154: (ID
2155: ,CLE_ID
2156: ,LINE_NUMBER
2157: ,DNZ_CHR_ID

Line 2252: ,OKC_K_LINES_B OKCLINB

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

Line 2322: ,OKC_K_LINES_B OKCLINB_SUBLINE

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:
2325: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2326: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID

Line 2323: ,OKC_K_LINES_B OKCLINB_LINE

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:
2325: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2326: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID
2327: AND OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID

Line 2384: ,OKC_K_LINES_B OKCLINB_LINE

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
2386: ,OKS_K_LINES_B OKSLINB
2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2388: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2385: ,OKC_K_LINES_B OKCLINB_SUBLINE

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
2386: ,OKS_K_LINES_B OKSLINB
2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2388: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2389:

Line 2510: ,OKC_K_LINES_B OKCLINB_LINE

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
2512: ,OKS_K_LINES_B OKSLINB
2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2514: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2511: ,OKC_K_LINES_B OKCLINB_SUBLINE

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
2512: ,OKS_K_LINES_B OKSLINB
2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2514: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2515:

Line 2538: INTO OKC_K_LINES_B

2534: l_stmt_num :=50;
2535:
2536: INSERT ALL
2537: WHEN (1=1) THEN
2538: INTO OKC_K_LINES_B
2539: (ID
2540: ,LINE_NUMBER
2541: ,CHR_ID
2542: ,CLE_ID

Line 2630: ,OKC_K_LINES_B OKCLINB_LINE

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
2633: ,OKS_INT_LINE_STG_TEMP LINSTG
2634: WHERE

Line 2738: ,OKC_K_LINES_B OKCLINB_SUBLINE

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
2741: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID
2742: and OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID

Line 2739: ,OKC_K_LINES_B OKCLINB_LINE

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
2741: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID
2742: and OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID
2743: and OUSGCNTSTG.LINE_NUMBER = OKCLINB_SUBLINE.LINE_NUMBER

Line 2865: ,OKC_K_LINES_B OKCLINB_SUBLINE

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

Line 2866: ,OKC_K_LINES_B OKCLINB_LINE

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
2868:
2869: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2870: AND OUSGCNTSTG.LINE_INTERFACE_ID =OLSTG.LINE_INTERFACE_ID