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.MRP_COMPONENTS_SC_V

Object Details

Object Name:	MRP_COMPONENTS_SC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_COMPONENTS_SC_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
QUERY_ID	NUMBER		Query identifier
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
COMPONENT_NUMBER	VARCHAR2	(40)	Component item name
USING_ASSEMBLY_NUMBER	VARCHAR2	(40)	Using assembly name
ORGANIZATION_ID	NUMBER		Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Organization code
COMPILE_DESIGNATOR	VARCHAR2	(10)	MPS, MRP or DRP plan identifier
CHANGE_NOTICE	VARCHAR2	(10)	Engineering change notice
USING_ASSEMBLY_ID	NUMBER		Using assembly identifier
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
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
REVISION	VARCHAR2	(3)	Item revision
EFFECTIVITY_DATE	DATE		Effective date
SUGGESTED_EFFECTIVITY_DATE	DATE		Suggested effective date
USE_UP_CODE	NUMBER		Engineering change notice use up code
USAGE_QUANTITY	NUMBER		Usage quantity
OPERATION_OFFSET_PERCENT	NUMBER		Operation offset percent
DRIVING_ITEM_ID	NUMBER		Driving item identifier
OPTIONAL_COMPONENT	NUMBER		Optional component flag
DISABLE_DATE	DATE		Disable date
WIP_SUPPLY_TYPE	VARCHAR2	(80)	WIP supply type
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)	Alternate Bill of Material Designator
FROM_UNIT_NUMBER	VARCHAR2	(30)	from unit number
TO_UNIT_NUMBER	VARCHAR2	(30)	to unit number

Query Text

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


SELECT QUERY_ID
,      INVENTORY_ITEM_ID
,      COMPONENT_NUMBER
,      USING_ASSEMBLY_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPILE_DESIGNATOR
,      CHANGE_NOTICE
,      USING_ASSEMBLY_ID
,      OPERATION_SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REVISION
,      EFFECTIVITY_DATE
,      SUGGESTED_EFFECTIVITY_DATE
,      USE_UP_CODE
,      USAGE_QUANTITY
,      OPERATION_OFFSET_PERCENT
,      DRIVING_ITEM_ID
,      OPTIONAL_COMPONENT
,      DISABLE_DATE
,      WIP_SUPPLY_TYPE
,      ALTERNATE_BOM_DESIGNATOR
,      FROM_UNIT_NUMBER
,      TO_UNIT_NUMBER
FROM APPS.MRP_COMPONENTS_SC_V;

Dependencies

[top of page]

APPS.MRP_COMPONENTS_SC_V references the following:

APPS: MFG_LOOKUPS; MRP_BOM_COMPONENTS; MRP_FORM_QUERY; MRP_SYSTEM_ITEMS; MTL_ITEM_FLEXFIELDS; MTL_PARAMETERS

APPS.MRP_COMPONENTS_SC_V is not referenced by any database object