[Home] [Help] [Dependency Information]
Object Name: | MSC_EAM_CMRO_SUPPLIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ACTIVITY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | Yes | ||
SR_INSTANCE_ID | NUMBER | Yes | ||
TRANSACTION_ID | NUMBER | Yes | ||
NEW_SCHEDULE_DATE | DATE | |||
ORDER_TYPE | NUMBER | Yes | ||
MAINTENANCE_OBJECT_SOURCE | NUMBER | |||
SCHEDULE_DESIGNATOR_ID | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (34) | ||
DISPOSITION_ID | NUMBER | |||
NEW_ORDER_QUANTITY | NUMBER | |||
WIP_START_QUANTITY | NUMBER | |||
EXPECTED_SCRAP_QTY | NUMBER | |||
QTY_SCRAPPED | NUMBER | |||
QTY_COMPLETED | NUMBER | |||
NEW_WIP_START_DATE | DATE | |||
FIRM_PLANNED_TYPE | NUMBER | Yes | ||
REVISION | VARCHAR2 | (10) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
PLANNING_GROUP | VARCHAR2 | (30) | ||
SCHEDULE_GROUP_ID | NUMBER | |||
SCHEDULE_GROUP_NAME | VARCHAR2 | (30) | ||
BUILD_SEQUENCE | NUMBER | |||
LINE_ID | NUMBER | |||
BILL_SEQUENCE_ID | NUMBER | |||
ROUTING_SEQUENCE_ID | NUMBER | |||
UNIT_NUMBER | VARCHAR2 | (30) | ||
PROCESS_SEQ_ID | NUMBER | |||
BY_PRODUCT_USING_ASSY_ID | NUMBER | |||
ORDER_NUMBER | VARCHAR2 | (240) | ||
WIP_STATUS_CODE | NUMBER | |||
COPRODUCTS_SUPPLY | NUMBER | |||
OPERATION_SEQ_NUM | NUMBER | |||
JUMP_OP_SEQ_NUM | NUMBER | |||
JOB_OP_SEQ_NUM | NUMBER | |||
QUANTITY_PER_ASSEMBLY | NUMBER | |||
QUANTITY_ISSUED | NUMBER | |||
WSM_FAULTY_NETWORK | NUMBER | |||
REQUESTED_START_DATE | DATE | |||
REQUESTED_COMPLETION_DATE | DATE | |||
SCHEDULE_PRIORITY | NUMBER | |||
ASSET_ITEM_ID | NUMBER | |||
ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | ||
ACTUAL_START_DATE | DATE | |||
ITEM_TYPE_VALUE | NUMBER | |||
ACTIVITY_TYPE | NUMBER | |||
CLASS_CODE | VARCHAR2 | (10) | ||
SHUTDOWN_TYPE | NUMBER | |||
TO_BE_EXPLODED | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (3) | ||
MAINTENANCE_TYPE_CODE | VARCHAR2 | (30) | ||
TOP_TRANSACTION_ID | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
PRODUCES_TO_STOCK | NUMBER | |||
PRODUCT_CLASSIFICATION | VARCHAR2 | (150) | ||
MAINTENANCE_REQUIREMENT | VARCHAR2 | (22) |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, INVENTORY_ITEM_ID
, ACTIVITY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, TRANSACTION_ID
, NEW_SCHEDULE_DATE
, ORDER_TYPE
, MAINTENANCE_OBJECT_SOURCE
, SCHEDULE_DESIGNATOR_ID
, DEMAND_CLASS
, DISPOSITION_ID
, NEW_ORDER_QUANTITY
, WIP_START_QUANTITY
, EXPECTED_SCRAP_QTY
, QTY_SCRAPPED
, QTY_COMPLETED
, NEW_WIP_START_DATE
, FIRM_PLANNED_TYPE
, REVISION
, PROJECT_ID
, TASK_ID
, PLANNING_GROUP
, SCHEDULE_GROUP_ID
, SCHEDULE_GROUP_NAME
, BUILD_SEQUENCE
, LINE_ID
, BILL_SEQUENCE_ID
, ROUTING_SEQUENCE_ID
, UNIT_NUMBER
, PROCESS_SEQ_ID
, BY_PRODUCT_USING_ASSY_ID
, ORDER_NUMBER
, WIP_STATUS_CODE
, COPRODUCTS_SUPPLY
, OPERATION_SEQ_NUM
, JUMP_OP_SEQ_NUM
, JOB_OP_SEQ_NUM
, QUANTITY_PER_ASSEMBLY
, QUANTITY_ISSUED
, WSM_FAULTY_NETWORK
, REQUESTED_START_DATE
, REQUESTED_COMPLETION_DATE
, SCHEDULE_PRIORITY
, ASSET_ITEM_ID
, ASSET_SERIAL_NUMBER
, ACTUAL_START_DATE
, ITEM_TYPE_VALUE
, ACTIVITY_TYPE
, CLASS_CODE
, SHUTDOWN_TYPE
, TO_BE_EXPLODED
, OBJECT_TYPE
, MAINTENANCE_TYPE_CODE
, TOP_TRANSACTION_ID
, DESCRIPTION
, PRODUCES_TO_STOCK
, PRODUCT_CLASSIFICATION
, MAINTENANCE_REQUIREMENT
FROM APPS.MSC_EAM_CMRO_SUPPLIES_V;
APPS.MSC_EAM_CMRO_SUPPLIES_V is not referenced by any database object
|
|
|