APPS.OKS_IMPORT_POST_INSERT dependencies on OKS_INT_HEADER_STG_TEMP

Line 270: ,OKS_INT_HEADER_STG_TEMP HDRSTG

266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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

Line 535: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
539: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 784: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
788: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1048: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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*/
1052: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 1236: ,OKS_INT_HEADER_STG_TEMP HDRSTG

1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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*/

Line 1468: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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*/
1472: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1718: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
1722: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1984: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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*/
1988: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 2179: ,OKS_INT_HEADER_STG_TEMP HDRSTG

2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
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*/

Line 2391: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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
2395: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2520: ,OKS_INT_HEADER_STG_TEMP HDRSTG

2516: ,OKCLINB_LINE.start_date as start_date
2517: ,OKCLINB_LINE.end_date as end_date
2518:
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

Line 2655: ,OKS_int_header_stg_temp HDRSTG

2651: ,OKS_NT_INT.NOTE_TYPE NOTE_TYPE
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'

Line 2678: ,OKS_INT_HEADER_STG_TEMP HDRSTG

2674: ,OKS_NT_INT.ENTERED_DATE ENTERED_DATE
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

Line 2922: ,OKS_INT_HEADER_STG_TEMP HDRSTG

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'
2926: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER