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

TABLE: CRP.CRP_RESOURCE_PLAN

Object Details
Object Name: CRP_RESOURCE_PLAN
Object Type: TABLE
Owner: CRP
FND Design Data: TableCRP.CRP_RESOURCE_PLAN
Subobject Name:
Status: VALID


CRP_RESOURCE_PLAN stores the resource requirements for WIP discrete
jobs, WIP nonstandard jobs, suggested planned orders, and suggested
repetitive schedules for a MRP plan.
.
SOURCE_TRANSACTION_ID uniquely identifies an order in
MRP_RECOMMENDATIONS.
.
In the case of a discrete resource requirement, the RESOURCE_END_DATE
and DAILY_RESOURCE_HOURS columns are NULL, and RESOURCE_DATE contains
the resource requirement date.
.
In the case of a repetitive requirement, RESOURCE_END_DATE contains
the end date of the requirement, DAILY_RESOURCE_HOURS contains the
daily resource requirement, RESOURCE_DATE contains the start date of
the requirement, and RESOURCE_HOURS contains the total resource
requirement over the period.
.
This table is populated by the memory based planner or the CRP
planner. It is used to display capacity requirements in the Planner's
Workbench form and by CRP inquiry and CRP reports to compile the
capacity plan.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CRP_RESOURCE_PLAN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
CRP_RESOURCE_PLAN_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnDESIGNATOR
ColumnRESOURCE_ID
ColumnDEPARTMENT_ID
ColumnASSEMBLY_ITEM_ID
CRP_RESOURCE_PLAN_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_TRANSACTION_ID
CRP_RESOURCE_PLAN_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSEMBLY_ITEM_ID
ColumnDESIGNATOR
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DEPARTMENT_ID NUMBER
Yes Department identifier
RESOURCE_ID NUMBER
Yes Resource identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
DESIGNATOR VARCHAR2 (10) Yes MRP plan identifier
SOURCE_TRANSACTION_ID NUMBER
Yes Order identifier
ASSEMBLY_ITEM_ID NUMBER
Yes Assembly item identifier
SOURCE_ITEM_ID NUMBER

Source item identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number in routing
RESOURCE_DATE DATE
Yes Resource need date
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
RESOURCE_HOURS NUMBER
Yes Resource hours needed
REPETITIVE_TYPE NUMBER
Yes Repetitive type
SUPPLY_TYPE NUMBER

Supply Type Identifier
RESOURCE_END_DATE DATE

Last date resource is needed for repetitive schedules
DAILY_RESOURCE_HOURS NUMBER

Daily resource hours needed for repetitive schedules
LOAD_RATE NUMBER

Load Rate
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DEPARTMENT_ID
,      RESOURCE_ID
,      ORGANIZATION_ID
,      DESIGNATOR
,      SOURCE_TRANSACTION_ID
,      ASSEMBLY_ITEM_ID
,      SOURCE_ITEM_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_DATE
,      RESOURCE_SEQ_NUM
,      RESOURCE_HOURS
,      REPETITIVE_TYPE
,      SUPPLY_TYPE
,      RESOURCE_END_DATE
,      DAILY_RESOURCE_HOURS
,      LOAD_RATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM CRP.CRP_RESOURCE_PLAN;

Dependencies

[top of page]

CRP.CRP_RESOURCE_PLAN does not reference any database object

CRP.CRP_RESOURCE_PLAN is referenced by following:

SchemaAPPS
SynonymCRP_RESOURCE_PLAN