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 OKC_K_HEADERS_ALL_B

Line 271: ,OKC_K_HEADERS_ALL_B OKCHDRB

267: ,bip.tce_code tce_code /*Added for bug:9019205*/
268: ,bip.quantity quantity
269: FROM OKS_INT_LINE_STG_TEMP OLSTG
270: ,OKS_INT_HEADER_STG_TEMP HDRSTG
271: ,OKC_K_HEADERS_ALL_B OKCHDRB
272: ,OKC_K_LINES_B OKCLINB_LINE
273: ,OKC_TIME_CODE_UNITS_B BIP
274: ,OKC_TIME_CODE_UNITS_TL BIPTL
275: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 534: ,OKC_K_HEADERS_ALL_B OKCHDRB

530: ,bip.quantity quantity /*Added for bug:9019205*/
531:
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

Line 783: ,OKC_K_HEADERS_ALL_B OKCHDRB

779: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG )INNER_1
780:
781: ,OKC_K_LINES_B OKCLINB_LINE
782: ,OKC_K_LINES_B OKCLINB_SUBLINE
783: ,OKC_K_HEADERS_ALL_B OKCHDRB
784: ,OKS_INT_HEADER_STG_TEMP HDRSTG
785: ,OKC_TIME_CODE_UNITS_B BIP
786: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
787: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 1047: ,OKC_K_HEADERS_ALL_B OKCHDRB

1043: ,USGSTG.SUBTOTAL STOTAL
1044: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG ) INNER_1
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*/

Line 1237: ,OKC_K_HEADERS_ALL_B OKCHDRB

1233: ,bip.tce_code tce_code
1234: ,bip.quantity quantity /*Added for bug:9019205*/
1235: FROM OKS_INT_LINE_STG_TEMP OLSTG
1236: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1237: ,OKC_K_HEADERS_ALL_B OKCHDRB
1238: ,OKC_K_LINES_B OKCLINB_LINE
1239: ,OKC_TIME_CODE_UNITS_B BIP
1240: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
1241: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1467: ,OKC_K_HEADERS_ALL_B OKCHDRB

1463: ,bip.quantity quantity /*Added for bug:9019205*/
1464:
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*/

Line 1717: ,OKC_K_HEADERS_ALL_B OKCHDRB

1713: WHERE CLI.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID )INNER_1
1714:
1715: ,OKC_K_LINES_B OKCLINB_LINE
1716: ,OKC_K_LINES_B OKCLINB_SUBLINE
1717: ,OKC_K_HEADERS_ALL_B OKCHDRB
1718: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1719: ,OKC_TIME_CODE_UNITS_B BIP
1720: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
1721: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 1983: ,OKC_K_HEADERS_ALL_B OKCHDRB

1979: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1980: WHERE CLI.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID ) INNER_1
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*/

Line 2180: ,OKC_K_HEADERS_ALL_B OKCHDRB

2176: ,bip.tce_code tce_code
2177: ,bip.quantity quantity /*Added for bug:9019205*/
2178: FROM OKS_INT_LINE_STG_TEMP OLSTG
2179: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2180: ,OKC_K_HEADERS_ALL_B OKCHDRB
2181: ,OKC_K_LINES_B OKCLINB_LINE
2182: ,OKC_TIME_CODE_UNITS_B BIP
2183: ,OKC_TIME_CODE_UNITS_TL BIPTL /*Added for bug:9019205*/
2184: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2390: ,OKC_K_HEADERS_ALL_B OKCHDRB

2386: ,bip.tce_code tce_code
2387: ,bip.quantity quantity
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

Line 2523: ,OKC_K_HEADERS_ALL_B OKCHDRB

2519: FROM OKS_INT_LINE_STG_TEMP OLSTG
2520: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2521: ,OKC_K_LINES_B OKCLINB_LINE
2522: ,OKS_K_LINES_B OKSLINB_LINE
2523: ,OKC_K_HEADERS_ALL_B OKCHDRB
2524: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2525: AND HDRSTG.INTERFACE_STATUS ='S'
2526: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2527: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2656: ,OKC_K_HEADERS_ALL_B OKCHDRB

2652: ,OKS_NT_INT.ENTERED_BY ENTERED_BY
2653: ,OKS_NT_INT.ENTERED_DATE ENTERED_DATE
2654: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2655: ,OKS_int_header_stg_temp HDRSTG
2656: ,OKC_K_HEADERS_ALL_B OKCHDRB
2657: WHERE OKS_NT_INT.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2658: AND OKS_NT_INT.LINE_INTERFACE_ID IS NULL
2659: AND HDRSTG.INTERFACE_STATUS ='S'
2660: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2679: ,OKC_K_HEADERS_ALL_B OKCHDRB

2675:
2676: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2677: ,OKS_INT_LINE_STG_TEMP OLSTG
2678: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2679: ,OKC_K_HEADERS_ALL_B OKCHDRB
2680: ,OKC_K_LINES_B OKCLINB
2681:
2682: WHERE OKS_NT_INT.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
2683: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2921: ,OKC_K_HEADERS_ALL_B OKCHDRB

2917: ,OKCLINB.ID LINB_ID
2918:
2919: FROM OKS_INT_LINE_STG_TEMP OLSTG
2920: ,OKC_K_LINES_B OKCLINB
2921: ,OKC_K_HEADERS_ALL_B OKCHDRB
2922: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2923:
2924: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2925: AND HDRSTG.INTERFACE_STATUS ='S'