AR_CONS_BILL_CYCLES_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

BILLING_CYCLE_ID CYCLE_NAME DESCRIPTION BILL_CYCLE_TYPE CYCLE_FREQUENCY START_DATE LAST_DAY DAY_1 DAY_2 DAY_3 DAY_4 DAY_5 DAY_6 DAY_7 DAY_8 DAY_9 DAY_10 DAY_11 DAY_12 DAY_13 DAY_14 DAY_15 DAY_16 DAY_17 DAY_18 DAY_19 DAY_20 DAY_21 DAY_22 DAY_23 DAY_24 DAY_25 DAY_26 DAY_27 DAY_28 DAY_29 DAY_30 DAY_31 DAY_MONDAY DAY_TUESDAY DAY_WEDNESDAY DAY_THURSDAY DAY_FRIDAY DAY_SATURDAY DAY_SUNDAY SKIP_WEEKENDS SKIP_HOLIDAYS REPEAT_DAILY REPEAT_WEEKLY REPEAT_MONTHLY DAY_TYPE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.BILLING_CYCLE_ID , T.CYCLE_NAME , T.DESCRIPTION , B.BILL_CYCLE_TYPE , B.CYCLE_FREQUENCY , B.START_DATE , B.LAST_DAY , B.DAY_1 , B.DAY_2 , B.DAY_3 , B.DAY_4 , B.DAY_5 , B.DAY_6 , B.DAY_7 , B.DAY_8 , B.DAY_9 , B.DAY_10 , B.DAY_11 , B.DAY_12 , B.DAY_13 , B.DAY_14 , B.DAY_15 , B.DAY_16 , B.DAY_17 , B.DAY_18 , B.DAY_19 , B.DAY_20 , B.DAY_21 , B.DAY_22 , B.DAY_23 , B.DAY_24 , B.DAY_25 , B.DAY_26 , B.DAY_27 , B.DAY_28 , B.DAY_29 , B.DAY_30 , B.DAY_31 , B.DAY_MONDAY , B.DAY_TUESDAY , B.DAY_WEDNESDAY , B.DAY_THURSDAY , B.DAY_FRIDAY , B.DAY_SATURDAY , B.DAY_SUNDAY , B.SKIP_WEEKENDS , B.SKIP_HOLIDAYS , B.REPEAT_DAILY , B.REPEAT_WEEKLY , B.REPEAT_MONTHLY , B.DAY_TYPE , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATE_LOGIN , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.OBJECT_VERSION_NUMBER from AR_CONS_BILL_CYCLES_B B , AR_CONS_BILL_CYCLES_TL T WHERE T.BILLING_CYCLE_ID = B.BILLING_CYCLE_ID and T.LANGUAGE = userenv('LANG')