DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on OKS_USAGE_COUNTERS_INTERFACE

Line 2626: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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
2630: ,OKC_K_LINES_B OKCLINB_LINE

Line 2734: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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
2738: ,OKC_K_LINES_B OKCLINB_SUBLINE

Line 2861: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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
2865: ,OKC_K_LINES_B OKCLINB_SUBLINE