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


VIEW: APPS.PJM_PROJECT_WIP_V

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

View Type

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


PJM_PROJECT_WIP_V returns all project-related WIP jobs.
This view corresponds to the WIP Job Summary (multi-row) and WIP Job Information (single-row) web inquiry regions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

System-generated number that uniquely identifies a project or seiban
TASK_ID NUMBER

System-generated number that uniquely identifies a task
JOB_ID NUMBER
Yes WIP job unique identifier
JOB_NAME VARCHAR2 (240) Yes WIP job name
JOB_DESCRIPTION VARCHAR2 (240)
WIP job description
JOB_CLASS VARCHAR2 (10) Yes WIP accounting class for this job
JOB_STATUS VARCHAR2 (80)
WIP job status
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ASSEMBLY VARCHAR2 (40)
Assembly item number
ASSEMBLY_DESCRIPTION VARCHAR2 (240)
Assembly item description
PRIMARY_ITEM_ID NUMBER

Assembly item unique identifier
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item model/unit number
START_DATE DATE
Yes Job start date
COMPLETION_DATE DATE
Yes Job completion date
START_QUANTITY NUMBER
Yes Job start quantity
PRIMARY_UOM VARCHAR2 (3)
Primary unit of measure of assembly item
QUANTITY_COMPLETED NUMBER

Current job completed quantity
QUANTITY_REMAINING NUMBER

Current job remaining quantity
QUANTITY_SCRAPPED NUMBER

Current job scrapped quantity
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference
BOM_REVISION VARCHAR2 (3)
Bill of Materials revision
ROUTING_REF_ID NUMBER

Rounding reference unique identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      JOB_ID
,      JOB_NAME
,      JOB_DESCRIPTION
,      JOB_CLASS
,      JOB_STATUS
,      ORGANIZATION_NAME
,      ASSEMBLY
,      ASSEMBLY_DESCRIPTION
,      PRIMARY_ITEM_ID
,      END_ITEM_UNIT_NUMBER
,      START_DATE
,      COMPLETION_DATE
,      START_QUANTITY
,      PRIMARY_UOM
,      QUANTITY_COMPLETED
,      QUANTITY_REMAINING
,      QUANTITY_SCRAPPED
,      BOM_REFERENCE_ID
,      BOM_REVISION
,      ROUTING_REF_ID
FROM APPS.PJM_PROJECT_WIP_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_WIP_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES

APPS.PJM_PROJECT_WIP_V is not referenced by any database object