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

VIEW: APPS.PJM_TASKS_MTLL_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


PJM_TASKS_MTLL_V is a view used solely by the Task segment of the Stock Locator flexfield. It does not contain any validation at all; validation is deferred to the Project Locator validation API because flexfield does not provide separate value sets for data entry (which requires strigent validation) and query (which requires no validation).


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes System-generated number that uniquely identifies a project
TASK_ID NUMBER (15) Yes System-generated number that uniquely identifies a task
TASK_NUMBER VARCHAR2 (25) Yes User-entered string that uniquely identifies a task within a project
TASK_NAME VARCHAR2 (20) Yes User-entered task name
VALID_FLAG VARCHAR2 (1)
Flag indicating task is valid or not
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      VALID_FLAG
FROM APPS.PJM_TASKS_MTLL_V;

Dependencies

[top of page]

APPS.PJM_TASKS_MTLL_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
ViewPA_LOOKUPS
SynonymPA_TASKS
PL/SQL PackagePA_TASK_UTILS - show dependent code
APPS.PJM_TASKS_MTLL_V is referenced by following:

SchemaAPPS
Package BodyINV_UI_TASK_LOVS - show dependent code
Package BodyWMS_RULES_WORKBENCH_PVT - show dependent code