VIEW: APPS.AR_CONS_BILL_CYCLES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, 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')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, 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')