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.PJM_PROJECT_WIP_V

Object Details

Object Name:	PJM_PROJECT_WIP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.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:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; MFG_LOOKUPS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.PJM_PROJECT_WIP_V is not referenced by any database object