APPS.OKS_IMPORT_INSERT dependencies on OKS_INT_USAGE_COUNTER_STG_TEMP

Line 195: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG

191: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL
192:
193: ,(SELECT SUM(NVL(USG.SUBTOTAL,0)) AS USG_SUBTOTAL
194: ,USG.LINE_INTERFACE_ID
195: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG
196: WHERE USG.STATUS_CODE <>'CANCELLED'
197: GROUP BY USG.LINE_INTERFACE_ID) INNER2_USG
198:
199: WHERE LSTG.LINE_INTERFACE_ID = INNER2_CVL.LINE_INTERFACE_ID(+)

Line 564: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG

560: AND COV.STATUS_CODE <>'CANCELLED'
561: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL
562: ,(SELECT SUM(NVL(USG.TAX_AMOUNT,0)) AS USG_TAX_AMT
563: ,USG.LINE_INTERFACE_ID
564: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG
565: WHERE USG.STATUS_CODE <>'CANCELLED'
566: GROUP BY USG.LINE_INTERFACE_ID) INNER2_USG
567: WHERE LSTG.LINE_INTERFACE_ID = INNER2_CVL.LINE_INTERFACE_ID(+)
568: AND LSTG.LINE_INTERFACE_ID = INNER2_USG.LINE_INTERFACE_ID(+)

Line 1576: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

1572: AND cvlint.status_code <>'CANCELLED'
1573: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1574: ,(SELECT SUM(USGSTG.SUBTOTAL ) AS SUBTOTAL
1575: ,USGSTG.LINE_INTERFACE_ID
1576: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
1577: WHERE USGSTG.STATUS_CODE <> 'CANCELLED'
1578: GROUP BY LINE_INTERFACE_ID )INNER_USG
1579: WHERE OHSTG.HEADER_INTERFACE_ID=OLSTG.HEADER_INTERFACE_ID
1580: AND OLSTG.LINE_INTERFACE_ID =INNER_Q.LINE_INTERFACE_ID

Line 1879: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

1875: AND CVLINT.STATUS_CODE <>'CANCELLED'
1876: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1877: ,(SELECT SUM(USGSTG.TAX_AMOUNT) AS TAX_AMOUNT
1878: ,USGSTG.LINE_INTERFACE_ID
1879: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
1880: WHERE USGSTG.STATUS_CODE <> 'CANCELLED'
1881: GROUP BY LINE_INTERFACE_ID )INNER_USG
1882: ,(SELECT OKSLB.PM_PROGRAM_ID AS PM_PROGRAM_ID
1883: ,OKSLB.PM_SCH_EXISTS_YN AS PM_SCH_EXISTS_YN

Line 2615: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2611: - ADD_MONTHS(OLSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
2612: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
2613: ,null CANCELLED_AMOUNT
2614:
2615: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2616: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2617: ,OKS_INT_LINE_STG_TEMP OLSTG
2618: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2619: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2622: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

2618: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2619: ,OKC_K_HEADERS_ALL_B OKCHDRB
2620: ,OKC_K_LINES_B OKCLINB_LINE
2621: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2622: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2623: ,OKS_INT_LINE_STG_TEMP LINSTG
2624: WHERE
2625: USGSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2626: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)

Line 2723: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2719: ,null ORIG_SYSTEM_SOURCE_CODE
2720: ,null ORIG_SYSTEM_ID1
2721: ,null ORIG_SYSTEM_REFERENCE1
2722: ,'T' BILLING_SCHEDULE_TYPE
2723: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2724: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2725: ,OKS_INT_LINE_STG_TEMP OLSTG
2726: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2727: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2850: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2846: ,null NUMBER_OF_ITEMS
2847: ,'Y' PRICED_ITEM_YN
2848: ,1 OBJECT_VERSION_NUMBER
2849:
2850: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2851: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2852: ,OKS_INT_LINE_STG_TEMP OLSTG
2853: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2854: ,OKC_K_HEADERS_ALL_B OKCHDRB