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

Object Details

Object Name:	WIP_ICX_COMPONENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_ICX_COMPONENTS_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

WIP_ICX_COMPONENTS_V shows component information for job/schedule operations. It is used for Self Service Web Applications.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive schedule identifier
REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number within a routing
INVENTORY_ITEM_ID	NUMBER		Yes	Item identifier
ITEM_NUMBER	VARCHAR2	(40)		Resolved item number
COMPONENT_DESCRIPTION	VARCHAR2	(240)		Item description
ITEM_PRIMARY_UOM	VARCHAR2	(3)		Item primary unit of measure
QUANTITY_PER_ASSEMBLY	NUMBER		Yes	Per usage quantity
SUPPLY_TYPE	VARCHAR2	(80)	Yes	Method of material consumption within WIP
ATTACHMENT	VARCHAR2	(4000)		Whether or not the item has attachments
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column

Query Text

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


SELECT WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      COMPONENT_DESCRIPTION
,      ITEM_PRIMARY_UOM
,      QUANTITY_PER_ASSEMBLY
,      SUPPLY_TYPE
,      ATTACHMENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.WIP_ICX_COMPONENTS_V;

Dependencies

[top of page]

APPS.WIP_ICX_COMPONENTS_V references the following:

APPS: BOM_DEPARTMENTS; FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_MESSAGE - show dependent code; MFG_LOOKUPS; MTL_SYSTEM_ITEMS_KFV; WIP_OPERATIONS; WIP_REQUIREMENT_OPERATIONS

APPS.WIP_ICX_COMPONENTS_V is not referenced by any database object