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: TablePA.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: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_BILLING_CYCLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnBILLING_CYCLE_ID
PA_BILLING_CYCLES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnBILLING_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:

SchemaPA
ViewPA_BILLING_CYCLES#