APPS.OKS_IMPORT_POST_INSERT dependencies on OKC_K_LINES_B

Line 252: ,OKC_K_LINES_B OKCLINB_LINE

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')
256: AND HDRSTG.INTERFACE_STATUS ='S'

Line 434: ,OKC_K_LINES_B OKCLINB_LINE

430: , OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
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:

Line 663: ,OKC_K_LINES_B OKCLINB_LINE

659: ,USGSTG.END_DATE END_DT
660: ,USGSTG.SUBTOTAL STOTAL
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

Line 664: ,OKC_K_LINES_B OKCLINB_SUBLINE

660: ,USGSTG.SUBTOTAL STOTAL
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

Line 873: ,OKC_K_LINES_B OKCLINB_LINE

869: ,USGSTG.START_DATE STR_DT
870: ,USGSTG.END_DATE END_DT
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

Line 874: ,OKC_K_LINES_B OKCLINB_SUBLINE

870: ,USGSTG.END_DATE END_DT
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

Line 1047: ,OKC_K_LINES_B OKCLINB_LINE

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')
1051: AND HDRSTG.INTERFACE_STATUS ='S'

Line 1221: ,OKC_K_LINES_B OKCLINB_LINE

1217: ,OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
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:

Line 1451: ,OKC_K_LINES_B OKCLINB_LINE

1447: FROM OKS_COVERED_LEVELS_INTERFACE CLI
1448: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
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

Line 1452: ,OKC_K_LINES_B OKCLINB_SUBLINE

1448: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
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

Line 1663: ,OKC_K_LINES_B OKCLINB_LINE

1659: ,CLI.SUBTOTAL STOTAL
1660: FROM OKS_COVERED_LEVELS_INTERFACE CLI
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

Line 1664: ,OKC_K_LINES_B OKCLINB_SUBLINE

1660: FROM OKS_COVERED_LEVELS_INTERFACE CLI
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

Line 1843: ,OKC_K_LINES_B OKCLINB_LINE

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')
1847: AND HDRSTG.INTERFACE_STATUS ='S'

Line 1997: ,OKC_K_LINES_B OKCLINB_LINE

1993: END) MID_SM_STR_DT
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

Line 2123: ,OKC_K_LINES_B OKCLINB_LINE

2119: ,OKCLINB_LINE.end_date as end_date
2120:
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'

Line 2282: ,OKC_K_LINES_B OKCLINB

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
2286: AND OKS_NT_INT.LINE_INTERFACE_ID IS NOT NULL

Line 2522: ,OKC_K_LINES_B OKCLINB

2518: ,OKCHDRB.ID HDRB_ID
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