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]

TABLE: PA.PA_BILLING_CYCLES

Object Details

Object Name:	PA_BILLING_CYCLES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BILLING_CYCLES
Subobject Name:
Status:	VALID

PA_BILLING_CYCLES stores the definition of a billing cycle that
specifies the rules that will be used to determine the next billing
date for a given project. This table has predefined data for some
standard cycles that Oracle Projects supports. You can define
your own rules if the standard cycles do not meet your
requirements.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BILLING_CYCLES_U1	NORMAL	UNIQUE	APPS_TS_SEED	BILLING_CYCLE_ID
PA_BILLING_CYCLES_U2	NORMAL	UNIQUE	APPS_TS_SEED	BILLING_CYCLE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BILLING_CYCLE_ID	NUMBER	(15)	Yes	The system generated identifier to uniquely identify a billing cycle
BILLING_CYCLE_NAME	VARCHAR2	(30)	Yes	The user defined unique name to identify a billing cycle.
BILLING_CYCLE_TYPE	VARCHAR2	(30)	Yes	The type of billing cycle.
DESCRIPTION	VARCHAR2	(250)		The description of the billing cycle.
START_DATE_ACTIVE	DATE		Yes	The first effective date of billing cycle.
END_DATE_ACTIVE	DATE			The last effective date of billing cycle.
BILLING_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Developer descriptive flexfield structure defining column.
BILLING_VALUE1	VARCHAR2	(150)		Developer descriptive flexfield segment.
BILLING_VALUE2	VARCHAR2	(150)		Developer descriptive flexfield segment.
BILLING_VALUE3	VARCHAR2	(150)		Developer descriptive flexfield segment.
BILLING_VALUE4	VARCHAR2	(150)		Developer descriptive flexfield segment.
BILLING_VALUE5	VARCHAR2	(150)		Developer descriptive flexfield segment.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field.

Query Text

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


SELECT BILLING_CYCLE_ID
,      BILLING_CYCLE_NAME
,      BILLING_CYCLE_TYPE
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      BILLING_ATTRIBUTE_CATEGORY
,      BILLING_VALUE1
,      BILLING_VALUE2
,      BILLING_VALUE3
,      BILLING_VALUE4
,      BILLING_VALUE5
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
FROM PA.PA_BILLING_CYCLES;

Dependencies

[top of page]

PA.PA_BILLING_CYCLES does not reference any database object

PA.PA_BILLING_CYCLES is referenced by following:

PA: PA_BILLING_CYCLES#