DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WIP_EAM_REQUIREMENTS_ALL_V

Object Details
Object Name: WIP_EAM_REQUIREMENTS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_EAM_REQUIREMENTS_ALL_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 Mandatory Comments
ROW_ID ROWID (10)
Row Id
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
CONCATENATED_SEGMENTS VARCHAR2 (40)
Concatenated Segments
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
ITEM_PRIMARY_UOM_CODE VARCHAR2 (3)
Item Primary Uom Code
INVENTORY_ASSET_FLAG VARCHAR2 (1)
Inventory Asset Flag
LOCATION_CONTROL_CODE NUMBER

Location Control Code
RESTRICT_LOCATORS_CODE NUMBER

Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE NUMBER

Restrict Subinventories Code
ORGANIZATION_ID NUMBER

Organization Id
WIP_ENTITY_ID NUMBER

Work Order Number
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
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
DEPARTMENT_ID NUMBER

Department Id
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
WIP_SUPPLY_TYPE NUMBER

Wip Supply Type Id
WIP_SUPPLY_MEANING VARCHAR2 (80)
Wip Supply Type Meaning
DATE_REQUIRED DATE

Required Date
REQUIRED_QUANTITY NUMBER

Required Quantity
QUANTITY_ISSUED NUMBER

Quantity Issued
QUANTITY_OPEN NUMBER

Quantity Open
QUANTITY_PER_ASSEMBLY NUMBER

Quantity per assembly
COMMENTS VARCHAR2 (240)
Comments
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply Subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply Locator Id
MRP_NET_FLAG NUMBER

MRP Net Flag
MPS_REQUIRED_QUANTITY NUMBER

MPS Required Quantity
MPS_DATE_REQUIRED DATE

MPS Date Required
ROUTING_EXISTS_FLAG NUMBER

Routing Exists Flag
FIRST_UNIT_START_DATE DATE

First Unit Start Date
FIRST_UNIT_COMPLETION_DATE DATE

First Unit Completion Date
LAST_UNIT_COMPLETION_DATE DATE

Last Unit Completion Date
QUANTITY_ALLOCATED NUMBER

Allocated Quantity
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Auto Request Material
Query Text

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


SELECT ROW_ID
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      ITEM_PRIMARY_UOM_CODE
,      INVENTORY_ASSET_FLAG
,      LOCATION_CONTROL_CODE
,      RESTRICT_LOCATORS_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      WIP_SUPPLY_TYPE
,      WIP_SUPPLY_MEANING
,      DATE_REQUIRED
,      REQUIRED_QUANTITY
,      QUANTITY_ISSUED
,      QUANTITY_OPEN
,      QUANTITY_PER_ASSEMBLY
,      COMMENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      MRP_NET_FLAG
,      MPS_REQUIRED_QUANTITY
,      MPS_DATE_REQUIRED
,      ROUTING_EXISTS_FLAG
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_COMPLETION_DATE
,      QUANTITY_ALLOCATED
,      AUTO_REQUEST_MATERIAL
FROM APPS.WIP_EAM_REQUIREMENTS_ALL_V;

Dependencies

[top of page]

APPS.WIP_EAM_REQUIREMENTS_ALL_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
ViewEAM_DIRECT_ITEM_RECS_V
PL/SQL PackageEAM_MATERIAL_ALLOCQTY_PKG - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_OPERATIONS
SynonymWIP_REQUIREMENT_OPERATIONS

APPS.WIP_EAM_REQUIREMENTS_ALL_V is not referenced by any database object