Product: | PA - Projects |
---|---|
Description: | PA_DELIVERABLE_TYPES_AMG_V selects all the attributes of a Deliverable Types. |
Implementation/DBA Data: | APPS.PA_DELIVERABLE_TYPES_AMG_V |
SELECT PTT.TASK_TYPE_ID
, PTT.TASK_TYPE
, PTT.TASK_TYPE_CLASS_CODE
, PLL.MEANING
, PTT.DESCRIPTION
, PTT.START_DATE_ACTIVE
, PTT.END_DATE_ACTIVE
, PTT.TASK_TYPE_CLASS_CODE
, PTT.INITIAL_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PTT.PROG_ENTRY_ENABLE_FLAG
, PTT.ENABLE_DLVR_ACTIONS_FLAG
, PTT.RECORD_VERSION_NUMBER
FROM PA_TASK_TYPES PTT
, PA_PROJECT_STATUSES PPS
, PA_LOOKUPS PLL
WHERE PTT.OBJECT_TYPE = 'PA_DLVR_TYPES'
AND PTT.INITIAL_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PLL.LOOKUP_TYPE = 'PA_DLVR_TYPE'
AND PLL.LOOKUP_CODE = PTT.TASK_TYPE_CLASS_CODE