DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on OKS_USAGE_COUNTERS_INTERFACE

Line 2616: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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

Line 2724: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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

Line 2851: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT

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