[Home] [Help]
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
276: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
529: ,bip.tce_code tce_code
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
777: ,USGSTG.END_DATE END_DT
778: ,USGSTG.SUBTOTAL STOTAL
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
778: ,USGSTG.SUBTOTAL STOTAL
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*/
1041: ,USGSTG.START_DATE STR_DT
1042: ,USGSTG.END_DATE END_DT
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
1042: ,USGSTG.END_DATE END_DT
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
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
1242: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1462: ,bip.tce_code tce_code
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
1711: FROM OKS_COVERED_LEVELS_INTERFACE CLI
1712: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
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
1712: ,OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG
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*/
1977: ,CLI.SUBTOTAL STOTAL
1978: FROM OKS_COVERED_LEVELS_INTERFACE CLI
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
1978: FROM OKS_COVERED_LEVELS_INTERFACE CLI
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
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
2185: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2385: ,OLSTG.LINE_TYPE LINE_TYPE
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
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
2525: AND HDRSTG.INTERFACE_STATUS ='S'
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
2684: AND OKS_NT_INT.LINE_INTERFACE_ID IS NOT NULL
2916: ,OKCHDRB.ID HDRB_ID
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