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 79: INTO OKS_STREAM_LEVELS_B

75: l_stmt_num := 10;
76:
77: INSERT ALL
78: WHEN (FREQUENCY IS NOT NULL) THEN
79: INTO OKS_STREAM_LEVELS_B
80: (ID
81: ,CHR_ID
82: ,CLE_ID
83: ,DNZ_CHR_ID

Line 501: FROM oks_stream_levels_b b

497: /*,nvl(OKS_STRM_LVL.LEVEL_AMOUNT,0) LEVEL_AMOUNT Bug:7916240*/
498: , (CASE WHEN (OKS_STRM_LVL.END_DATE = OLSTG.END_DATE) THEN
499: (CASE WHEN OKS_STRM_LVL.UOM_CODE <>'DAY' and OKS_STRM_LVL.LEVEL_PERIODS = OLSTG.RECUR_BILL_OCCURANCES then
500: nvl( SUBTOTAL- (SELECT Sum(level_amount * LEVEL_PERIODS)
501: FROM oks_stream_levels_b b
502: WHERE b.cle_id = OKCLINB_LINE.ID
503: GROUP BY b.cle_id ),SUBTOTAL) + NVL(OKS_STRM_LVL.LEVEL_AMOUNT,0)*(OKS_STRM_LVL.LEVEL_PERIODS)
504: ELSE
505: nvl( SUBTOTAL- (SELECT Sum(level_amount * LEVEL_PERIODS)

Line 506: FROM oks_stream_levels_b b

502: WHERE b.cle_id = OKCLINB_LINE.ID
503: GROUP BY b.cle_id ),SUBTOTAL) + NVL(OKS_STRM_LVL.LEVEL_AMOUNT,0)*(OKS_STRM_LVL.LEVEL_PERIODS)
504: ELSE
505: nvl( SUBTOTAL- (SELECT Sum(level_amount * LEVEL_PERIODS)
506: FROM oks_stream_levels_b b
507: WHERE b.cle_id = OKCLINB_LINE.ID
508: GROUP BY b.cle_id ),SUBTOTAL) + NVL(OKS_STRM_LVL.LEVEL_AMOUNT,0)
509: END)
510: ELSE

Line 536: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

532: FROM OKS_INT_LINE_STG_TEMP OLSTG
533: ,OKC_K_LINES_B OKCLINB_LINE
534: ,OKC_K_HEADERS_ALL_B OKCHDRB
535: ,OKS_INT_HEADER_STG_TEMP HDRSTG
536: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
537: ,OKC_TIME_CODE_UNITS_B BIP
538: ,OKC_TIME_CODE_UNITS_TL BIPTL
539: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
540: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 614: INTO OKS_STREAM_LEVELS_B

610: l_stmt_num := 10;
611:
612: INSERT ALL
613: WHEN (FREQUENCY IS NOT NULL ) then
614: INTO OKS_STREAM_LEVELS_B
615: (ID
616: ,CHR_ID
617: ,CLE_ID
618: ,DNZ_CHR_ID

Line 1049: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1045: ,OKC_K_LINES_B OKCLINB_LINE
1046: ,OKC_K_LINES_B OKCLINB_SUBLINE
1047: ,OKC_K_HEADERS_ALL_B OKCHDRB
1048: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1049: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
1050: ,OKC_TIME_CODE_UNITS_B BIP
1051: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
1052: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
1053: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1083: INTO OKS_STREAM_LEVELS_B

1079: l_stmt_num :=40;
1080:
1081: INSERT ALL
1082: WHEN (FREQUENCY IS NOT NULL) THEN
1083: INTO OKS_STREAM_LEVELS_B
1084: (ID
1085: ,CHR_ID
1086: ,CLE_ID
1087: ,DNZ_CHR_ID

Line 1469: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1465: FROM OKS_INT_LINE_STG_TEMP OLSTG
1466: ,OKC_K_LINES_B OKCLINB_LINE
1467: ,OKC_K_HEADERS_ALL_B OKCHDRB
1468: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1469: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
1470: ,OKC_TIME_CODE_UNITS_B BIP
1471: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
1472: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1473: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1546: INTO OKS_STREAM_LEVELS_B

1542: l_stmt_num := 10;
1543:
1544: INSERT ALL
1545: WHEN (FREQUENCY IS NOT NULL ) then
1546: INTO OKS_STREAM_LEVELS_B
1547: (ID
1548: ,CHR_ID
1549: ,CLE_ID
1550: ,DNZ_CHR_ID

Line 1985: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

1981: ,OKC_K_LINES_B OKCLINB_LINE
1982: ,OKC_K_LINES_B OKCLINB_SUBLINE
1983: ,OKC_K_HEADERS_ALL_B OKCHDRB
1984: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1985: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
1986: ,OKC_TIME_CODE_UNITS_B BIP
1987: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
1988: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
1989: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2018: INTO OKS_STREAM_LEVELS_B

2014: l_stmt_num := 40;
2015:
2016: INSERT ALL
2017: WHEN (FREQUENCY IS NOT NULL) THEN
2018: INTO OKS_STREAM_LEVELS_B
2019: (ID
2020: ,CHR_ID
2021: ,CLE_ID
2022: ,DNZ_CHR_ID

Line 2392: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

2388: FROM OKS_INT_LINE_STG_TEMP OLSTG
2389: ,OKC_K_LINES_B OKCLINB_LINE
2390: ,OKC_K_HEADERS_ALL_B OKCHDRB
2391: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2392: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL
2393: ,OKC_TIME_CODE_UNITS_B BIP
2394: ,OKC_TIME_CODE_UNITS_TL BIPTL
2395: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2396: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER