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_IND_RATE_SCH_REVISIONS

Object Details

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

PA_IND_RATE_SCH_REVISIONS stores revisions of burden
schedules with different effective dates. Each
revision is a group of burden rates that are effective
between the start date and end date of the revision.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_IND_RATE_SCH_REVISIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IND_RATE_SCH_REVISION_ID
PA_IND_RATE_SCH_REVISIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	IND_RATE_SCH_ID IND_RATE_SCH_REVISION IND_RATE_SCH_REVISION_TYPE
PA_IND_RATE_SCH_REVISIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_PLUS_STRUCTURE
PA_IND_RATE_SCH_REVISIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTUAL_SCH_REVISION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IND_RATE_SCH_REVISION_ID	NUMBER	(15)	Yes	The system-generated number which uniquely identifies the burden schedule revision
IND_RATE_SCH_ID	NUMBER	(15)	Yes	The identifier of the burden schedule that the revision belongs to
IND_RATE_SCH_REVISION	VARCHAR2	(30)	Yes	The implementation-defined name of the burden schedule revision
IND_RATE_SCH_REVISION_TYPE	VARCHAR2	(1)	Yes	The type of the burden schedule revision
COMPILED_FLAG	VARCHAR2	(1)	Yes	Flag indicates whether the burden schedule revision is compiled
COST_PLUS_STRUCTURE	VARCHAR2	(30)	Yes	The name of the burden structure that the burden schedule uses for burdening
START_DATE_ACTIVE	DATE		Yes	First effective date of the burden schedule revision
END_DATE_ACTIVE	DATE			Last effective date of the burden schedule revision
COMPILED_DATE	DATE			The date when the burden schedule revision was compiled
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
READY_TO_COMPILE_FLAG	VARCHAR2	(1)	Yes	Flag indicates if the burden schedule is ready for compilation
ACTUAL_SCH_REVISION_ID	NUMBER	(15)		The identifier of the actual burden schedule revision which applied on the provisional burden schedule revision
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)	Yes	Identifier of the default organization hierarchy used for burdening for the burden schedule version.
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)	Yes	Identifier of the burden hierarchy version for the burden schedule.
START_ORGANIZATION_ID	NUMBER	(15)	Yes	Identifier of the highest organization used for the burden hierarchy.

Query Text

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


SELECT IND_RATE_SCH_REVISION_ID
,      IND_RATE_SCH_ID
,      IND_RATE_SCH_REVISION
,      IND_RATE_SCH_REVISION_TYPE
,      COMPILED_FLAG
,      COST_PLUS_STRUCTURE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COMPILED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      READY_TO_COMPILE_FLAG
,      ACTUAL_SCH_REVISION_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      START_ORGANIZATION_ID
FROM PA.PA_IND_RATE_SCH_REVISIONS;

Dependencies

[top of page]

PA.PA_IND_RATE_SCH_REVISIONS does not reference any database object

PA.PA_IND_RATE_SCH_REVISIONS is referenced by following:

APPS: PA_IND_RATE_SCH_REVISIONS