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

VIEW: APPS.PJM_PROJECT_WIP_COMP_V

Object Details
Object Name: PJM_PROJECT_WIP_COMP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_PROJECT_WIP_COMP_V
Subobject Name:
Status: VALID

View Type

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


PJM_PROJECT_WIP_COMP_V returns component information for each WIP job.
This view corresponds to the Components web inquiry region.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROWID or row identifier for WIP_REQUIREMENT_OPERATIONS
INVENTORY_ITEM_ID NUMBER

Component item unique identifier
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item number or concatenated segments of item Flexfield
ITEM_DESCRIPTION VARCHAR2 (240)
Item description of component
ITEM_PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure of component
INVENTORY_ASSET_FLAG VARCHAR2 (1)
Flag indicating component is asset or expense item
LOCATION_CONTROL_CODE VARCHAR2 (4000)
Locator control for the component
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (4000)
Flag indicating whether component is restricted to a pre-defined list of subinventories
RESTRICT_LOCATORS_CODE VARCHAR2 (4000)
Flag indicating whether component is restricted to a pre-defined list of stock locators
ORGANIZATION_ID NUMBER

Organization unique identifier
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
LINE_ID NUMBER

WIP line unique identifier
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

Extended Who column
PROGRAM_APPLICATION_ID NUMBER

Extended Who column
PROGRAM_ID NUMBER

Extended Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
DEPARTMENT_ID NUMBER

Department identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department name
WIP_SUPPLY_TYPE NUMBER

Code identifying method of material consumption within WIP
WIP_SUPPLY_MEANING VARCHAR2 (80)
Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER

Total quantity required
QUANTITY_ISSUED NUMBER

Quantity already issued to WIP
QUANTITY_OPEN NUMBER

Quantity remaining
QUANTITY_PER_ASSEMBLY NUMBER

Quantity needed for each assembly
COMMENTS VARCHAR2 (240)
Component comment descriptive text
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Subinventory used to supply component to WIP
SUPPLY_LOCATOR_ID NUMBER

Unique identifier of locator used to supply component to WIP
SUPPLY_LOCATOR VARCHAR2 (4000)
Locator, in concatenated segments, used to supply component to WIP
MRP_NET_FLAG VARCHAR2 (4000)
Whether or not MRP should consider the component requirement in its netting process
MPS_REQUIRED_QUANTITY NUMBER

Quantity used by MPS relief process
MPS_DATE_REQUIRED DATE

Date used by MPS relief process
ROUTING_EXISTS_FLAG VARCHAR2 (4000)
Whether routing exists for job or repetitive schedules
FIRST_UNIT_START_DATE DATE

First unit scheduled receipt date
FIRST_UNIT_COMPLETION_DATE DATE

First unit scheduled completion date
LAST_UNIT_COMPLETION_DATE DATE

Latest unit scheduled completion date
COMPONENT_SERIAL VARCHAR2 (4000)
Comma separated list of serial numbers of this component
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_SUBINVENTORIES_CODE
,      RESTRICT_LOCATORS_CODE
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      REPETITIVE_SCHEDULE_ID
,      LINE_ID
,      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
,      SUPPLY_LOCATOR
,      MRP_NET_FLAG
,      MPS_REQUIRED_QUANTITY
,      MPS_DATE_REQUIRED
,      ROUTING_EXISTS_FLAG
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_COMPLETION_DATE
,      COMPONENT_SERIAL
FROM APPS.PJM_PROJECT_WIP_COMP_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_WIP_COMP_V references the following:

SchemaAPPS
PL/SQL PackageINV_PROJECT - show dependent code
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_PARAMETERS
PL/SQL PackagePJM_INQUIRY - show dependent code
ViewWIP_REQUIREMENT_OPERATIONS_V

APPS.PJM_PROJECT_WIP_COMP_V is not referenced by any database object