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


VIEW: APPS.WIP_JOB_OPEN_ALLOCATIONS_V

Object Details
Object Name: WIP_JOB_OPEN_ALLOCATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_JOB_OPEN_ALLOCATIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_NAME VARCHAR2 (240) Yes Job name
ORGANIZATION_ID NUMBER
Yes Organization identifier
WIP_ENTITY_ID NUMBER
Yes WIP entity identifier
JOB_DESCRIPTION VARCHAR2 (240)
Job description
PRIMARY_ITEM VARCHAR2 (40)
Primary item
PRIMARY_ITEM_DESCRIPTION VARCHAR2 (240)
Primary item description
PRIMARY_ITEM_ID NUMBER

Primary item identifier
STATUS_TYPE NUMBER
Yes Status type
STATUS VARCHAR2 (80) Yes Status
FIRST_OPEN_REQUIREMENTS_DATE DATE

First open requirements date
START_DATE DATE
Yes start date
COMPLETION_DATE DATE
Yes Completion date
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item unit number
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
LINE_CODE VARCHAR2 (10)
Line code
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Schedule group name
BUILD_SEQUENCE NUMBER

Query Text

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


SELECT WIP_ENTITY_NAME
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      JOB_DESCRIPTION
,      PRIMARY_ITEM
,      PRIMARY_ITEM_DESCRIPTION
,      PRIMARY_ITEM_ID
,      STATUS_TYPE
,      STATUS
,      FIRST_OPEN_REQUIREMENTS_DATE
,      START_DATE
,      COMPLETION_DATE
,      END_ITEM_UNIT_NUMBER
,      PROJECT_ID
,      TASK_ID
,      LINE_CODE
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
FROM APPS.WIP_JOB_OPEN_ALLOCATIONS_V;

Dependencies

[top of page]

APPS.WIP_JOB_OPEN_ALLOCATIONS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_TXN_REQUEST_LINES
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_OPERATIONS
SynonymWIP_PARAMETERS
SynonymWIP_REQUIREMENT_OPERATIONS
SynonymWIP_SCHEDULE_GROUPS

APPS.WIP_JOB_OPEN_ALLOCATIONS_V is not referenced by any database object