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: ViewWIP.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:

SchemaAPPS
SynonymBOM_EXPLOSIONS
ViewBOM_INVENTORY_COMPONENTS
SynonymBOM_OPERATIONAL_ROUTINGS
SynonymBOM_OPERATION_SEQUENCES
SynonymBOM_STANDARD_OPERATIONS
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.WIP_EXPLOSIONS_V is referenced by following:

SchemaAPPS
Package BodyWIP_PICKING_PVT - show dependent code