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]

VIEW: APPS.MSC_EAM_CMRO_SUPPLIES_V

Object Details

Object Name:	MSC_EAM_CMRO_SUPPLIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

APPS.MSC_EAM_CMRO_SUPPLIES_V references the following:

APPS: MSC_PLAN_ORGANIZATIONS; MSC_PLAN_SCHEDULES; MSC_SUPPLIES

APPS.MSC_EAM_CMRO_SUPPLIES_V is not referenced by any database object