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_USING_ASSEMBLY_SC_V

Object Details

Object Name:	MRP_USING_ASSEMBLY_SC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_USING_ASSEMBLY_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		Unique query idkentifier
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
COMPONENT_NUMBER	VARCHAR2	(40)	Component item name
USING_ASSEMBLY_NUMBER	VARCHAR2	(40)	Using assembly item 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 code
USING_ASSEMBLY_ID	NUMBER		Using assembly item identifier
OPERATION_SEQ_NUM	NUMBER		Manufacturing 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)	Inventory item revision code
EFFECTIVITY_DATE	DATE		Effectivity date
SUGGESTED_EFFECTIVITY_DATE	DATE		Suggested effectivity date
USE_UP_CODE	NUMBER		ECO use up code
USAGE_QUANTITY	NUMBER		Quantity per operation
OPERATION_OFFSET_PERCENT	NUMBER		Operation offset percent
DRIVING_ITEM_ID	NUMBER
OPTIONAL_COMPONENT	NUMBER		Item whose inventory use up date will drive the suggested effectivity date of the ECO
DISABLE_DATE	DATE		ECO disable date
WIP_SUPPLY_TYPE	VARCHAR2	(80)	Lookup meaning for WIP supply
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_USING_ASSEMBLY_SC_V;

Dependencies

[top of page]

APPS.MRP_USING_ASSEMBLY_SC_V references the following:

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

APPS.MRP_USING_ASSEMBLY_SC_V is not referenced by any database object