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

Object Details

Object Name:	ICX_EDM_WIP_JOB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_EDM_WIP_JOB_V
Subobject Name:
Status:	VALID

View Type

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

The ICX_EDM_WIP_JOB_V view returns work in process jobs that are
linked to a project / task.
.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER			Project / Seiban unique identifier
TASK_ID	NUMBER			Task unique identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project / Seiban number
TASK_NUMBER	VARCHAR2	(4000)		Task number
WIP_JOB	VARCHAR2	(240)	Yes	WIP job number
JOB_DESCRIPTION	VARCHAR2	(240)		WIP job description
CLASS	VARCHAR2	(10)	Yes	WIP accounting class
STATUS	VARCHAR2	(80)		Job status
BOM_REVISION	VARCHAR2	(3)		Inventory item revision code
ALTERNATE_BOM	VARCHAR2	(10)		Alternate bill used in a job
ORGANIZATION_CODE	VARCHAR2	(3)		Inventory organization code
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Inventory organization name
ASSEMBLY	VARCHAR2	(40)		Job assembly item number
ASSEMBLY_DESCRIPTION	VARCHAR2	(240)		Assembly item description
PRIMARY_UOM	VARCHAR2	(3)		Assembly item primary unit of measure
START_DATE	DATE		Yes	Job start date
START_QUANTITY	NUMBER		Yes	Start quantity
COMPLETION_DATE	DATE		Yes	Job copletion date
QUANTITY_COMPLETED	NUMBER			Current job quantity completed
QUANTITY_REMAINING	NUMBER			Current job quantity remaining
QUANTITY_SCRAPPED	NUMBER			Current job scrapped units
WIP_JOB_ID	NUMBER		Yes	WIP job unique identifier
ORGANIZATION_ID	NUMBER		Yes	Inventory organization unique identifier
PRIMARY_ITEM_ID	NUMBER			Assembly item unique identifier
COMMON_BOM_SEQUENCE_ID	NUMBER			Bill of material identifier when a common bill is used

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      WIP_JOB
,      JOB_DESCRIPTION
,      CLASS
,      STATUS
,      BOM_REVISION
,      ALTERNATE_BOM
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ASSEMBLY
,      ASSEMBLY_DESCRIPTION
,      PRIMARY_UOM
,      START_DATE
,      START_QUANTITY
,      COMPLETION_DATE
,      QUANTITY_COMPLETED
,      QUANTITY_REMAINING
,      QUANTITY_SCRAPPED
,      WIP_JOB_ID
,      ORGANIZATION_ID
,      PRIMARY_ITEM_ID
,      COMMON_BOM_SEQUENCE_ID
FROM APPS.ICX_EDM_WIP_JOB_V;

Dependencies

[top of page]

APPS.ICX_EDM_WIP_JOB_V references the following:

APPS: HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MFG_LOOKUPS; MRP_GET_PROJECT - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.ICX_EDM_WIP_JOB_V is not referenced by any database object