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_POST_INSERT dependencies on OKS_STREAM_LEVELS_B

Line 72: INTO OKS_STREAM_LEVELS_B

68: l_stmt_num := 10;
69:
70: INSERT ALL
71: WHEN (FREQUENCY IS NOT NULL) THEN
72: INTO OKS_STREAM_LEVELS_B
73: (ID
74: ,CHR_ID
75: ,CLE_ID
76: ,DNZ_CHR_ID

Line 437: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

433: FROM OKS_INT_LINE_STG_TEMP OLSTG
434: ,OKC_K_LINES_B OKCLINB_LINE
435: ,OKC_K_HEADERS_ALL_B OKCHDRB
436: ,OKS_INT_HEADER_STG_TEMP HDRSTG
437: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
438:
439: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
440: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
441: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 510: INTO OKS_STREAM_LEVELS_B

506: l_stmt_num := 10;
507:
508: INSERT ALL
509: WHEN (FREQUENCY IS NOT NULL ) then
510: INTO OKS_STREAM_LEVELS_B
511: (ID
512: ,CHR_ID
513: ,CLE_ID
514: ,DNZ_CHR_ID

Line 877: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

873: ,OKC_K_LINES_B OKCLINB_LINE
874: ,OKC_K_LINES_B OKCLINB_SUBLINE
875: ,OKC_K_HEADERS_ALL_B OKCHDRB
876: ,OKS_INT_HEADER_STG_TEMP HDRSTG
877: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
878: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
879: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
880: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
881: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 905: INTO OKS_STREAM_LEVELS_B

901: l_stmt_num :=40;
902:
903: INSERT ALL
904: WHEN (FREQUENCY IS NOT NULL) THEN
905: INTO OKS_STREAM_LEVELS_B
906: (ID
907: ,CHR_ID
908: ,CLE_ID
909: ,DNZ_CHR_ID

Line 1224: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1220: FROM OKS_INT_LINE_STG_TEMP OLSTG
1221: ,OKC_K_LINES_B OKCLINB_LINE
1222: ,OKC_K_HEADERS_ALL_B OKCHDRB
1223: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1224: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
1225:
1226: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1227: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1228: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1296: INTO OKS_STREAM_LEVELS_B

1292: l_stmt_num := 10;
1293:
1294: INSERT ALL
1295: WHEN (FREQUENCY IS NOT NULL ) then
1296: INTO OKS_STREAM_LEVELS_B
1297: (ID
1298: ,CHR_ID
1299: ,CLE_ID
1300: ,DNZ_CHR_ID

Line 1667: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1663: ,OKC_K_LINES_B OKCLINB_LINE
1664: ,OKC_K_LINES_B OKCLINB_SUBLINE
1665: ,OKC_K_HEADERS_ALL_B OKCHDRB
1666: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1667: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
1668: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
1669: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1670: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1671: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1694: INTO OKS_STREAM_LEVELS_B

1690: l_stmt_num := 40;
1691:
1692: INSERT ALL
1693: WHEN (FREQUENCY IS NOT NULL) THEN
1694: INTO OKS_STREAM_LEVELS_B
1695: (ID
1696: ,CHR_ID
1697: ,CLE_ID
1698: ,DNZ_CHR_ID

Line 2000: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1996: FROM OKS_INT_LINE_STG_TEMP OLSTG
1997: ,OKC_K_LINES_B OKCLINB_LINE
1998: ,OKC_K_HEADERS_ALL_B OKCHDRB
1999: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2000: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
2001: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2002: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2003: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')
2004: AND HDRSTG.INTERFACE_STATUS ='S'