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

VIEW: APPS.PJM_PROJECT_TASK_LS_ITEM_SUM_V

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

View Type

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


PJM_PROJECT_TASK_LS_ITEM_SUM_V returns task-related line schedule item summary information.
This view corresponds to the Task Line Item web inquiry region.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_CODE VARCHAR2 (10)
Production line code
LINE_ID NUMBER

Production line unique identifier
PROJECT_ID NUMBER

System-generated number that uniquely identifies a project
TASK_ID NUMBER

System-generated number that uniquely identifies a task
ITEM_NUMBER VARCHAR2 (40)
Item number
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item model/unit number
PRIMARY_ITEM_ID NUMBER

Inventory item unique identifier for the assembly
PLANNED_QUANTITY NUMBER

Initial planned quantity
QUANTITY_COMPLETED NUMBER

Quantity completed
VARIANCE_QUANTITY NUMBER

Variance quantity
Query Text

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


SELECT LINE_CODE
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      ITEM_NUMBER
,      END_ITEM_UNIT_NUMBER
,      PRIMARY_ITEM_ID
,      PLANNED_QUANTITY
,      QUANTITY_COMPLETED
,      VARIANCE_QUANTITY
FROM APPS.PJM_PROJECT_TASK_LS_ITEM_SUM_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_TASK_LS_ITEM_SUM_V references the following:

SchemaAPPS
ViewPJM_LINE_SCHEDULES_V

APPS.PJM_PROJECT_TASK_LS_ITEM_SUM_V is not referenced by any database object