VIEW: APPS.PA_DELIVERABLE_TYPES_AMG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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