eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AR.AR_CONS_BILL_CYCLES_B#

Object Details

Object Name:	AR_CONS_BILL_CYCLES_B#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BILLING_CYCLE_ID	NUMBER	(15)	Yes
BILL_CYCLE_TYPE	VARCHAR2	(30)
START_DATE	DATE
CYCLE_FREQUENCY	VARCHAR2	(30)
LAST_DAY	VARCHAR2	(1)
DAY_1	VARCHAR2	(1)
DAY_2	VARCHAR2	(1)
DAY_3	VARCHAR2	(1)
DAY_4	VARCHAR2	(1)
DAY_5	VARCHAR2	(1)
DAY_6	VARCHAR2	(1)
DAY_7	VARCHAR2	(1)
DAY_8	VARCHAR2	(1)
DAY_9	VARCHAR2	(1)
DAY_10	VARCHAR2	(1)
DAY_11	VARCHAR2	(1)
DAY_12	VARCHAR2	(1)
DAY_13	VARCHAR2	(1)
DAY_14	VARCHAR2	(1)
DAY_15	VARCHAR2	(1)
DAY_16	VARCHAR2	(1)
DAY_17	VARCHAR2	(1)
DAY_18	VARCHAR2	(1)
DAY_19	VARCHAR2	(1)
DAY_20	VARCHAR2	(1)
DAY_21	VARCHAR2	(1)
DAY_22	VARCHAR2	(1)
DAY_23	VARCHAR2	(1)
DAY_24	VARCHAR2	(1)
DAY_25	VARCHAR2	(1)
DAY_26	VARCHAR2	(1)
DAY_27	VARCHAR2	(1)
DAY_28	VARCHAR2	(1)
DAY_29	VARCHAR2	(1)
DAY_30	VARCHAR2	(1)
DAY_31	VARCHAR2	(1)
DAY_MONDAY	VARCHAR2	(1)
DAY_TUESDAY	VARCHAR2	(1)
DAY_WEDNESDAY	VARCHAR2	(1)
DAY_THURSDAY	VARCHAR2	(1)
DAY_FRIDAY	VARCHAR2	(1)
SKIP_WEEKENDS	VARCHAR2	(1)
SKIP_HOLIDAYS	VARCHAR2	(1)
REPEAT_DAILY	NUMBER	(15)
REPEAT_WEEKLY	NUMBER	(15)
REPEAT_MONTHLY	NUMBER	(15)
DAY_TYPE	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(15)
DAY_SATURDAY	VARCHAR2	(1)
DAY_SUNDAY	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BILLING_CYCLE_ID
,      BILL_CYCLE_TYPE
,      START_DATE
,      CYCLE_FREQUENCY
,      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
,      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
,      DAY_SATURDAY
,      DAY_SUNDAY
,      ZD_EDITION_NAME
FROM AR.AR_CONS_BILL_CYCLES_B#;

Dependencies

[top of page]

AR.AR_CONS_BILL_CYCLES_B# references the following:

AR: AR_CONS_BILL_CYCLES_B

AR.AR_CONS_BILL_CYCLES_B# is referenced by following:

APPS: AR_CONS_BILL_CYCLES_B; AR_CONS_BILL_CYCLES_B+