DBA Data[Home] [Help]

APPS.OKS_IMPORT_POST_INSERT dependencies on OKC_TIME_CODE_UNITS_B

Line 273: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 537: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 785: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 1050: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 1239: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 1470: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 1719: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 1986: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 2182: ,OKC_TIME_CODE_UNITS_B BIP

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

Line 2393: ,OKC_TIME_CODE_UNITS_B BIP

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