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 903: ,OKC_K_LINES_B OKCLINB

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

Line 1212: ,OKC_K_LINES_B OKCLINB

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:
1214: WHERE HDRSTG.INTERFACE_STATUS='S'
1215: AND LINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1216: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1375: ,OKC_K_LINES_B OKCLINB

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

Line 1434: INTO OKC_K_LINES_B

1430: l_stmt_num := 10;
1431:
1432: INSERT ALL
1433: WHEN (1=1) THEN
1434: INTO OKC_K_LINES_B
1435: (ID
1436: ,LINE_NUMBER
1437: ,CHR_ID
1438: ,CLE_ID

Line 1693: FROM OKC_K_LINES_B OKCLINB

1689: ELSE 'Y'
1690: END ) PRICED_ITEM_YN
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:

Line 1870: ,OKC_K_LINES_B OKCLINB

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

Line 1948: ,OKC_K_LINES_B OKCLINB

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

Line 2017: FROM OKC_K_LINES_B OKCLINB

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

Line 2075: FROM OKC_K_LINES_B OKCLINB

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

Line 2145: INTO OKC_K_LINES_B

2141: l_stmt_num := 10;
2142:
2143: INSERT ALL
2144: WHEN (1=1) THEN
2145: INTO OKC_K_LINES_B
2146: (ID
2147: ,CLE_ID
2148: ,LINE_NUMBER
2149: ,DNZ_CHR_ID

Line 2242: ,OKC_K_LINES_B OKCLINB

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

Line 2312: ,OKC_K_LINES_B OKCLINB_SUBLINE

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

Line 2313: ,OKC_K_LINES_B OKCLINB_LINE

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:
2315: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = OCLVLSTG.COVERED_LEVEL_INTERFACE_ID
2316: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID
2317: AND OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID

Line 2374: ,OKC_K_LINES_B OKCLINB_LINE

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
2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2378: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2375: ,OKC_K_LINES_B OKCLINB_SUBLINE

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
2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2378: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2379:

Line 2500: ,OKC_K_LINES_B OKCLINB_LINE

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
2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2504: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2501: ,OKC_K_LINES_B OKCLINB_SUBLINE

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
2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2504: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2505:

Line 2528: INTO OKC_K_LINES_B

2524: l_stmt_num :=50;
2525:
2526: INSERT ALL
2527: WHEN (1=1) THEN
2528: INTO OKC_K_LINES_B
2529: (ID
2530: ,LINE_NUMBER
2531: ,CHR_ID
2532: ,CLE_ID

Line 2620: ,OKC_K_LINES_B OKCLINB_LINE

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
2623: ,OKS_INT_LINE_STG_TEMP LINSTG
2624: WHERE

Line 2728: ,OKC_K_LINES_B OKCLINB_SUBLINE

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

Line 2729: ,OKC_K_LINES_B OKCLINB_LINE

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
2731: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID
2732: and OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID
2733: and OUSGCNTSTG.LINE_NUMBER = OKCLINB_SUBLINE.LINE_NUMBER

Line 2855: ,OKC_K_LINES_B OKCLINB_SUBLINE

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

Line 2856: ,OKC_K_LINES_B OKCLINB_LINE

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
2858:
2859: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2860: AND OUSGCNTSTG.LINE_INTERFACE_ID =OLSTG.LINE_INTERFACE_ID