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

TABLE: MSC.MSC_ST_RESOURCE_REQUIREMENTS

Object Details
Object Name: MSC_ST_RESOURCE_REQUIREMENTS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_RESOURCE_REQUIREMENTS
Subobject Name:
Status: VALID

The staging table used by the collection program to validate and process data for table MSC_RESOURCE_REQUIREMENTS.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEPARTMENT_ID NUMBER

Department identifier
RESOURCE_ID NUMBER

Resource identifier
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
SUPPLY_ID NUMBER

Supply identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number
OPERATION_SEQUENCE_ID NUMBER

Operation sequence identifier
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
START_DATE DATE

Start date of the resource requirement
OPERATION_HOURS_REQUIRED NUMBER

Operation hours required
HOURS_EXPENDED NUMBER

Hours expended
DEMAND_CLASS VARCHAR2 (34)
Demand class code
BASIS_TYPE NUMBER

Basis type
ASSIGNED_UNITS NUMBER

Assigned units
END_DATE DATE

End date of the resource requirement
WIP_JOB_TYPE NUMBER

WIP job type
SCHEDULED_COMPLETION_DATE DATE

Schedule completion date
SCHEDULED_QUANTITY NUMBER

Quantity scheduled
QUANTITY_COMPLETED NUMBER

Quantity completed
DELETED_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
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
SR_INSTANCE_ID NUMBER

Source application instance identifier
REFRESH_ID NUMBER

Refresh identifier
WIP_ENTITY_ID NUMBER

WIP job identifier
STD_OP_CODE VARCHAR2 (4)
Standard OP code
SUPPLY_TYPE NUMBER

Supply type
CUMMULATIVE_QAUNTITY NUMBER

Department identifier
MINIMUM_TRANSFER_QUANTITY NUMBER

Department identifier
FIRM_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
WIP_ENTITY_NAME VARCHAR2 (240)
WIP Job Identifier
ITEM_NAME VARCHAR2 (250)
Item Name
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
OPERATION_SEQ_CODE VARCHAR2 (10)
Operation Sequence Code
RESOURCE_SEQ_CODE VARCHAR2 (10)
Resource Sequence Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
RESOURCE_CODE VARCHAR2 (10)
Resource Sequence Identifier
ROUTING_NAME VARCHAR2 (250)
Routing name
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
OPERATION_EFFECTIVITY_DATE DATE

Effectivity date
ALTERNATE_NUMBER NUMBER

Priority
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Type indicating the source of the records
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
BATCH_ID NUMBER

Batch identifier generated during pre-processing
PARENT_SEQ_NUM NUMBER

SETUP_ID NUMBER

SCHEDULE_FLAG NUMBER

QUANTITY_IN_QUEUE NUMBER

QUANTITY_RUNNING NUMBER

QUANTITY_WAITING_TO_MOVE NUMBER

YIELD NUMBER

USAGE_RATE NUMBER

ACTIVITY_GROUP_ID NUMBER

PRINCIPAL_FLAG NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_DEPARTMENT_ID NUMBER

SOURCE_RESOURCE_ID NUMBER

SOURCE_RESOURCE_SEQ_NUM NUMBER

SOURCE_OPERATION_SEQUENCE_ID NUMBER

SOURCE_WIP_ENTITY_ID NUMBER

SOURCE_OPERATION_SEQ_NUM NUMBER

ORIG_RESOURCE_SEQ_NUM NUMBER

ROUTING_SEQUENCE_ID NUMBER

GROUP_SEQUENCE_ID NUMBER

GROUP_SEQUENCE_NUMBER NUMBER

BATCH_NUMBER NUMBER

MAXIMUM_ASSIGNED_UNITS NUMBER

MINIMUM_CAPACITY NUMBER

MAXIMUM_CAPACITY NUMBER

BREAKABLE_ACTIVITY_FLAG NUMBER

STEP_QUANTITY NUMBER

STEP_QUANTITY_UOM VARCHAR2 (3)
UNADJUSTED_RESOURCE_HOURS NUMBER

TOUCH_TIME NUMBER

ACTUAL_START_DATE DATE

ACTIVITY_NAME VARCHAR2 (20)
OPERATION_NAME VARCHAR2 (240)
OPERATION_STATUS NUMBER

SHUTDOWN_TYPE VARCHAR2 (30)
SCHEDULE_DESIGNATOR_ID NUMBER

OBJECT_TYPE VARCHAR2 (3)
DISPOSITION_ID NUMBER

MAINTENANCE_OBJECT_SOURCE NUMBER

OPERATING_FLEET NUMBER

MAINTENANCE_REQUIREMENT VARCHAR2 (30)
OPERATION_CODE VARCHAR2 (200)
ACTUAL_END_DATE DATE

CLASS_CODE VARCHAR2 (10)
Query Text

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


SELECT DEPARTMENT_ID
,      RESOURCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUPPLY_ID
,      OPERATION_SEQ_NUM
,      OPERATION_SEQUENCE_ID
,      RESOURCE_SEQ_NUM
,      START_DATE
,      OPERATION_HOURS_REQUIRED
,      HOURS_EXPENDED
,      DEMAND_CLASS
,      BASIS_TYPE
,      ASSIGNED_UNITS
,      END_DATE
,      WIP_JOB_TYPE
,      SCHEDULED_COMPLETION_DATE
,      SCHEDULED_QUANTITY
,      QUANTITY_COMPLETED
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      WIP_ENTITY_ID
,      STD_OP_CODE
,      SUPPLY_TYPE
,      CUMMULATIVE_QAUNTITY
,      MINIMUM_TRANSFER_QUANTITY
,      FIRM_FLAG
,      COMPANY_ID
,      COMPANY_NAME
,      WIP_ENTITY_NAME
,      ITEM_NAME
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      OPERATION_SEQ_CODE
,      RESOURCE_SEQ_CODE
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      ROUTING_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      OPERATION_EFFECTIVITY_DATE
,      ALTERNATE_NUMBER
,      ERROR_TEXT
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      PARENT_SEQ_NUM
,      SETUP_ID
,      SCHEDULE_FLAG
,      QUANTITY_IN_QUEUE
,      QUANTITY_RUNNING
,      QUANTITY_WAITING_TO_MOVE
,      YIELD
,      USAGE_RATE
,      ACTIVITY_GROUP_ID
,      PRINCIPAL_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_DEPARTMENT_ID
,      SOURCE_RESOURCE_ID
,      SOURCE_RESOURCE_SEQ_NUM
,      SOURCE_OPERATION_SEQUENCE_ID
,      SOURCE_WIP_ENTITY_ID
,      SOURCE_OPERATION_SEQ_NUM
,      ORIG_RESOURCE_SEQ_NUM
,      ROUTING_SEQUENCE_ID
,      GROUP_SEQUENCE_ID
,      GROUP_SEQUENCE_NUMBER
,      BATCH_NUMBER
,      MAXIMUM_ASSIGNED_UNITS
,      MINIMUM_CAPACITY
,      MAXIMUM_CAPACITY
,      BREAKABLE_ACTIVITY_FLAG
,      STEP_QUANTITY
,      STEP_QUANTITY_UOM
,      UNADJUSTED_RESOURCE_HOURS
,      TOUCH_TIME
,      ACTUAL_START_DATE
,      ACTIVITY_NAME
,      OPERATION_NAME
,      OPERATION_STATUS
,      SHUTDOWN_TYPE
,      SCHEDULE_DESIGNATOR_ID
,      OBJECT_TYPE
,      DISPOSITION_ID
,      MAINTENANCE_OBJECT_SOURCE
,      OPERATING_FLEET
,      MAINTENANCE_REQUIREMENT
,      OPERATION_CODE
,      ACTUAL_END_DATE
,      CLASS_CODE
FROM MSC.MSC_ST_RESOURCE_REQUIREMENTS;

Dependencies

[top of page]

MSC.MSC_ST_RESOURCE_REQUIREMENTS does not reference any database object

MSC.MSC_ST_RESOURCE_REQUIREMENTS is referenced by following:

SchemaMSC
ViewMSC_ST_RESOURCE_REQUIREMENTS#