[Home] [Help] [Dependency Information]
Object Name: | MSC_RESOURCE_REQUIREMENTS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | ||
PLAN_ID | NUMBER | Yes | ||
SUPPLY_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
SR_INSTANCE_ID | NUMBER | Yes | ||
ROUTING_SEQUENCE_ID | NUMBER | |||
OPERATION_SEQUENCE_ID | NUMBER | |||
RESOURCE_SEQ_NUM | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | Yes | ||
DEPARTMENT_ID | NUMBER | |||
ALTERNATE_NUM | NUMBER | |||
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
BKT_START_DATE | NUMBER | |||
RESOURCE_HOURS | NUMBER | Yes | ||
SET_UP | NUMBER | |||
BKT_END_DATE | NUMBER | |||
TEAR_DOWN | NUMBER | |||
AGGREGATE_RESOURCE_ID | NUMBER | |||
SCHEDULE_FLAG | NUMBER | |||
PARENT_ID | NUMBER | |||
STD_OP_CODE | VARCHAR2 | (4) | ||
WIP_ENTITY_ID | NUMBER | |||
ASSIGNED_UNITS | NUMBER | Yes | ||
BASIS_TYPE | NUMBER | |||
OPERATION_SEQ_NUM | NUMBER | |||
LOAD_RATE | NUMBER | |||
DAILY_RESOURCE_HOURS | NUMBER | |||
STATUS | NUMBER | |||
APPLIED | NUMBER | |||
UPDATED | NUMBER | |||
SUBST_RES_FLAG | NUMBER | |||
REFRESH_NUMBER | NUMBER | |||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SOURCE_ITEM_ID | NUMBER | (38) | ||
ASSEMBLY_ITEM_ID | NUMBER | (38) | ||
SUPPLY_TYPE | NUMBER | (38) | ||
FIRM_START_DATE | DATE | |||
FIRM_END_DATE | DATE | |||
FIRM_FLAG | NUMBER | |||
CUMMULATIVE_QUANTITY | NUMBER | |||
YIELD | NUMBER | |||
REVERSE_CUMULATIVE_YIELD | NUMBER | |||
BATCH_NUMBER | NUMBER | |||
MINIMUM_TRANSFER_QUANTITY | NUMBER | |||
REMAINING_CAPACITY | NUMBER | |||
OVERLOADED_CAPACITY | NUMBER | |||
EARLIEST_START_DATE | DATE | |||
EARLIEST_COMPLETION_DATE | DATE | |||
SCHEDULED_DEMAND_ID | NUMBER | |||
ULPSD | DATE | |||
ULPCD | DATE | |||
UEPSD | DATE | |||
UEPCD | DATE | |||
EACD | DATE | |||
PARENT_SEQ_NUM | NUMBER | |||
SETUP_ID | NUMBER | |||
QUANTITY_IN_QUEUE | NUMBER | |||
QUANTITY_RUNNING | NUMBER | |||
QUANTITY_WAITING_TO_MOVE | NUMBER | |||
QUANTITY_COMPLETED | NUMBER | |||
USAGE_RATE | NUMBER | |||
HOURS_EXPENDED | NUMBER | |||
RECORD_SOURCE | NUMBER | |||
ACTIVITY_GROUP_ID | NUMBER | |||
PRINCIPAL_FLAG | NUMBER | |||
ORIG_RESOURCE_SEQ_NUM | NUMBER | |||
GROUP_SEQUENCE_ID | NUMBER | |||
GROUP_SEQUENCE_NUMBER | NUMBER | |||
MAXIMUM_ASSIGNED_UNITS | NUMBER | |||
MINIMUM_CAPACITY | NUMBER | |||
MAXIMUM_CAPACITY | NUMBER | |||
BREAKABLE_ACTIVITY_FLAG | NUMBER | |||
CAPACITY_CONSUMED_RATIO | NUMBER | |||
FROM_SETUP_ID | NUMBER | |||
STEP_QUANTITY | NUMBER | |||
STEP_QUANTITY_UOM | VARCHAR2 | (3) | ||
UNADJUSTED_RESOURCE_HOURS | NUMBER | |||
TOUCH_TIME | NUMBER | |||
JIT_END_DATE | DATE | |||
UNBUCKETED_START_DATE | DATE | |||
UNBUCKETED_END_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
TOTAL_RESOURCE_HOURS | NUMBER | |||
ACTIVITY_NAME | VARCHAR2 | (20) | ||
OPERATION_NAME | VARCHAR2 | (240) | ||
OPERATION_STATUS | NUMBER | |||
SHUTDOWN_TYPE | VARCHAR2 | (30) | ||
OPERATION_CODE | VARCHAR2 | (200) | ||
ACTUAL_END_DATE | DATE | |||
MAINTENANCE_OBJECT_SOURCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, PLAN_ID
, SUPPLY_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, ROUTING_SEQUENCE_ID
, OPERATION_SEQUENCE_ID
, RESOURCE_SEQ_NUM
, RESOURCE_ID
, DEPARTMENT_ID
, ALTERNATE_NUM
, START_DATE
, END_DATE
, BKT_START_DATE
, RESOURCE_HOURS
, SET_UP
, BKT_END_DATE
, TEAR_DOWN
, AGGREGATE_RESOURCE_ID
, SCHEDULE_FLAG
, PARENT_ID
, STD_OP_CODE
, WIP_ENTITY_ID
, ASSIGNED_UNITS
, BASIS_TYPE
, OPERATION_SEQ_NUM
, LOAD_RATE
, DAILY_RESOURCE_HOURS
, STATUS
, APPLIED
, UPDATED
, SUBST_RES_FLAG
, REFRESH_NUMBER
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_ITEM_ID
, ASSEMBLY_ITEM_ID
, SUPPLY_TYPE
, FIRM_START_DATE
, FIRM_END_DATE
, FIRM_FLAG
, CUMMULATIVE_QUANTITY
, YIELD
, REVERSE_CUMULATIVE_YIELD
, BATCH_NUMBER
, MINIMUM_TRANSFER_QUANTITY
, REMAINING_CAPACITY
, OVERLOADED_CAPACITY
, EARLIEST_START_DATE
, EARLIEST_COMPLETION_DATE
, SCHEDULED_DEMAND_ID
, ULPSD
, ULPCD
, UEPSD
, UEPCD
, EACD
, PARENT_SEQ_NUM
, SETUP_ID
, QUANTITY_IN_QUEUE
, QUANTITY_RUNNING
, QUANTITY_WAITING_TO_MOVE
, QUANTITY_COMPLETED
, USAGE_RATE
, HOURS_EXPENDED
, RECORD_SOURCE
, ACTIVITY_GROUP_ID
, PRINCIPAL_FLAG
, ORIG_RESOURCE_SEQ_NUM
, GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER
, MAXIMUM_ASSIGNED_UNITS
, MINIMUM_CAPACITY
, MAXIMUM_CAPACITY
, BREAKABLE_ACTIVITY_FLAG
, CAPACITY_CONSUMED_RATIO
, FROM_SETUP_ID
, STEP_QUANTITY
, STEP_QUANTITY_UOM
, UNADJUSTED_RESOURCE_HOURS
, TOUCH_TIME
, JIT_END_DATE
, UNBUCKETED_START_DATE
, UNBUCKETED_END_DATE
, ACTUAL_START_DATE
, TOTAL_RESOURCE_HOURS
, ACTIVITY_NAME
, OPERATION_NAME
, OPERATION_STATUS
, SHUTDOWN_TYPE
, OPERATION_CODE
, ACTUAL_END_DATE
, MAINTENANCE_OBJECT_SOURCE
FROM MSC.MSC_RESOURCE_REQUIREMENTS#;
|
|
|