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_EXPLOSIONS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
OPERATION_SEQ_NUM	NUMBER			Operation sequence number
LINE_OP	NUMBER		Yes	Line operation
LINE_OP_CODE	VARCHAR2	(4)	Yes	Line operation code
COMPONENT	VARCHAR2	(40)		Component
COMPONENT_ITEM_ID	NUMBER		Yes	Component item identifier
COMPONENT_DESCRIPTION	VARCHAR2	(240)		Component description
COMPONENT_QUANTITY	NUMBER			Component quantity
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supply subinventory code
SUPPLY_LOCATOR_ID	NUMBER			Supply locator identifier
WIP_SUPPLY_TYPE	NUMBER			WIP supply type
COMPONENT_CODE	VARCHAR2	(2000)		Component code
MTL_TRANSACTIONS_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag for Inventory transactions enabled
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary UOM code
REVISION_QTY_CONTROL_CODE	NUMBER			Revision quantity control code
TOP_BILL_SEQUENCE_ID	NUMBER		Yes	Top bill sequence identifier
TOP_ITEM_ID	NUMBER		Yes	Top item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
EFFECTIVITY_DATE	DATE			Effectivity date
DISABLE_DATE	DATE			Disable date
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing designator

Query Text

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


SELECT ROW_ID
,      OPERATION_SEQ_NUM
,      LINE_OP
,      LINE_OP_CODE
,      COMPONENT
,      COMPONENT_ITEM_ID
,      COMPONENT_DESCRIPTION
,      COMPONENT_QUANTITY
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      WIP_SUPPLY_TYPE
,      COMPONENT_CODE
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      PRIMARY_UOM_CODE
,      REVISION_QTY_CONTROL_CODE
,      TOP_BILL_SEQUENCE_ID
,      TOP_ITEM_ID
,      ORGANIZATION_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      ALTERNATE_ROUTING_DESIGNATOR
FROM APPS.WIP_EXPLOSIONS_V;

Dependencies

[top of page]

APPS.WIP_EXPLOSIONS_V references the following:

APPS: BOM_EXPLOSIONS; BOM_INVENTORY_COMPONENTS; BOM_OPERATIONAL_ROUTINGS; BOM_OPERATION_SEQUENCES; BOM_STANDARD_OPERATIONS; MTL_SYSTEM_ITEMS_KFV

APPS.WIP_EXPLOSIONS_V is referenced by following:

APPS: WIP_PICKING_PVT - show dependent code