APPS.OKS_IMPORT_POST_INSERT dependencies on OKC_K_HEADERS_ALL_B

Line 251: ,OKC_K_HEADERS_ALL_B OKCHDRB

247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
248:
249: FROM OKS_INT_LINE_STG_TEMP OLSTG
250: ,OKS_INT_HEADER_STG_TEMP HDRSTG
251: ,OKC_K_HEADERS_ALL_B OKCHDRB
252: ,OKC_K_LINES_B OKCLINB_LINE
253: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
254: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
255: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 435: ,OKC_K_HEADERS_ALL_B OKCHDRB

431: ,OLSTG.LINE_TYPE LINE_TYPE
432:
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

Line 665: ,OKC_K_HEADERS_ALL_B OKCHDRB

661: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG )INNER_1
662:
663: ,OKC_K_LINES_B OKCLINB_LINE
664: ,OKC_K_LINES_B OKCLINB_SUBLINE
665: ,OKC_K_HEADERS_ALL_B OKCHDRB
666: ,OKS_INT_HEADER_STG_TEMP HDRSTG
667: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
668: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
669: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 875: ,OKC_K_HEADERS_ALL_B OKCHDRB

871: ,USGSTG.SUBTOTAL STOTAL
872: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG ) INNER_1
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

Line 1046: ,OKC_K_HEADERS_ALL_B OKCHDRB

1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1043:
1044: FROM OKS_INT_LINE_STG_TEMP OLSTG
1045: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1046: ,OKC_K_HEADERS_ALL_B OKCHDRB
1047: ,OKC_K_LINES_B OKCLINB_LINE
1048: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1049: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1050: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1222: ,OKC_K_HEADERS_ALL_B OKCHDRB

1218: ,OLSTG.LINE_TYPE LINE_TYPE
1219:
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

Line 1453: ,OKC_K_HEADERS_ALL_B OKCHDRB

1449: WHERE CLI.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID )INNER_1
1450:
1451: ,OKC_K_LINES_B OKCLINB_LINE
1452: ,OKC_K_LINES_B OKCLINB_SUBLINE
1453: ,OKC_K_HEADERS_ALL_B OKCHDRB
1454: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1455: WHERE INNER_1.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
1456: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1457: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1665: ,OKC_K_HEADERS_ALL_B OKCHDRB

1661: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
1662: WHERE CLI.COVERED_LEVEL_INTERFACE_ID = CVLSTG.COVERED_LEVEL_INTERFACE_ID ) INNER_1
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

Line 1842: ,OKC_K_HEADERS_ALL_B OKCHDRB

1838: ,SYSDATE LAST_UPDATE_DATE
1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1840: FROM OKS_INT_LINE_STG_TEMP OLSTG
1841: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1842: ,OKC_K_HEADERS_ALL_B OKCHDRB
1843: ,OKC_K_LINES_B OKCLINB_LINE
1844: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1845: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1846: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1998: ,OKC_K_HEADERS_ALL_B OKCHDRB

1994: ,OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
1995: ,OLSTG.LINE_TYPE LINE_TYPE
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

Line 2125: ,OKC_K_HEADERS_ALL_B OKCHDRB

2121: FROM OKS_INT_LINE_STG_TEMP OLSTG
2122: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2123: ,OKC_K_LINES_B OKCLINB_LINE
2124: ,OKS_K_LINES_B OKSLINB_LINE
2125: ,OKC_K_HEADERS_ALL_B OKCHDRB
2126: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2127: AND HDRSTG.INTERFACE_STATUS ='S'
2128: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2129: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2258: ,OKC_K_HEADERS_ALL_B OKCHDRB

2254: ,OKS_NT_INT.ENTERED_BY ENTERED_BY
2255: ,OKS_NT_INT.ENTERED_DATE ENTERED_DATE
2256: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2257: ,OKS_int_header_stg_temp HDRSTG
2258: ,OKC_K_HEADERS_ALL_B OKCHDRB
2259: WHERE OKS_NT_INT.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2260: AND OKS_NT_INT.LINE_INTERFACE_ID IS NULL
2261: AND HDRSTG.INTERFACE_STATUS ='S'
2262: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 2281: ,OKC_K_HEADERS_ALL_B OKCHDRB

2277:
2278: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2279: ,OKS_INT_LINE_STG_TEMP OLSTG
2280: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2281: ,OKC_K_HEADERS_ALL_B OKCHDRB
2282: ,OKC_K_LINES_B OKCLINB
2283:
2284: WHERE OKS_NT_INT.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
2285: AND OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2523: ,OKC_K_HEADERS_ALL_B OKCHDRB

2519: ,OKCLINB.ID LINB_ID
2520:
2521: FROM OKS_INT_LINE_STG_TEMP OLSTG
2522: ,OKC_K_LINES_B OKCLINB
2523: ,OKC_K_HEADERS_ALL_B OKCHDRB
2524: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2525:
2526: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2527: AND HDRSTG.INTERFACE_STATUS ='S'