APPS.OKS_IMPORT_INSERT dependencies on OKS_INT_USAGE_COUNTER_STG_TEMP

Line 200: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG

196: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL
197:
198: ,(SELECT SUM(NVL(USG.SUBTOTAL,0)) AS USG_SUBTOTAL
199: ,USG.LINE_INTERFACE_ID
200: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG
201: WHERE USG.STATUS_CODE <>'CANCELLED'
202: GROUP BY USG.LINE_INTERFACE_ID) INNER2_USG
203:
204: WHERE LSTG.LINE_INTERFACE_ID = INNER2_CVL.LINE_INTERFACE_ID(+)

Line 569: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG

565: AND COV.STATUS_CODE <>'CANCELLED'
566: GROUP BY COV.LINE_INTERFACE_ID ) INNER2_CVL
567: ,(SELECT SUM(NVL(USG.TAX_AMOUNT,0)) AS USG_TAX_AMT
568: ,USG.LINE_INTERFACE_ID
569: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USG
570: WHERE USG.STATUS_CODE <>'CANCELLED'
571: GROUP BY USG.LINE_INTERFACE_ID) INNER2_USG
572: WHERE LSTG.LINE_INTERFACE_ID = INNER2_CVL.LINE_INTERFACE_ID(+)
573: AND LSTG.LINE_INTERFACE_ID = INNER2_USG.LINE_INTERFACE_ID(+)

Line 1581: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

1577: AND cvlint.status_code <>'CANCELLED'
1578: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1579: ,(SELECT SUM(USGSTG.SUBTOTAL ) AS SUBTOTAL
1580: ,USGSTG.LINE_INTERFACE_ID
1581: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
1582: WHERE USGSTG.STATUS_CODE <> 'CANCELLED'
1583: GROUP BY LINE_INTERFACE_ID )INNER_USG
1584: WHERE OHSTG.HEADER_INTERFACE_ID=OLSTG.HEADER_INTERFACE_ID
1585: AND OLSTG.LINE_INTERFACE_ID =INNER_Q.LINE_INTERFACE_ID

Line 1887: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

1883: AND CVLINT.STATUS_CODE <>'CANCELLED'
1884: GROUP BY CVLSTG.LINE_INTERFACE_ID) INNER_CLVL
1885: ,(SELECT SUM(USGSTG.TAX_AMOUNT) AS TAX_AMOUNT
1886: ,USGSTG.LINE_INTERFACE_ID
1887: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
1888: WHERE USGSTG.STATUS_CODE <> 'CANCELLED'
1889: GROUP BY LINE_INTERFACE_ID )INNER_USG
1890: ,(SELECT OKSLB.PM_PROGRAM_ID AS PM_PROGRAM_ID
1891: ,OKSLB.PM_SCH_EXISTS_YN AS PM_SCH_EXISTS_YN

Line 2625: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2621: - ADD_MONTHS(OLSTG.START_DATE, INNER_Q.NYEARS*12), 366, 1, 0)))
2622: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
2623: ,null CANCELLED_AMOUNT
2624:
2625: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2626: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2627: ,OKS_INT_LINE_STG_TEMP OLSTG
2628: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2629: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2632: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG

2628: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2629: ,OKC_K_HEADERS_ALL_B OKCHDRB
2630: ,OKC_K_LINES_B OKCLINB_LINE
2631: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2632: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2633: ,OKS_INT_LINE_STG_TEMP LINSTG
2634: WHERE
2635: USGSTG.LINE_INTERFACE_ID = LINSTG.LINE_INTERFACE_ID
2636: AND LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)

Line 2733: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2729: ,null ORIG_SYSTEM_SOURCE_CODE
2730: ,null ORIG_SYSTEM_ID1
2731: ,null ORIG_SYSTEM_REFERENCE1
2732: ,'T' BILLING_SCHEDULE_TYPE
2733: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2734: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2735: ,OKS_INT_LINE_STG_TEMP OLSTG
2736: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2737: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2860: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG

2856: ,null NUMBER_OF_ITEMS
2857: ,'Y' PRICED_ITEM_YN
2858: ,1 OBJECT_VERSION_NUMBER
2859:
2860: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2861: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2862: ,OKS_INT_LINE_STG_TEMP OLSTG
2863: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2864: ,OKC_K_HEADERS_ALL_B OKCHDRB