FND Design Data [Home] [Help]

View: AR_CONS_BILL_CYCLES_VL

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.AR_CONS_BILL_CYCLES_VL
View Text

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')

Columns

Name
ROW_ID
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