Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_CONS_BILL_CYCLES_VL |
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')