View: PA_LAUNCH_PAGE_ACTIONS_V

Product:	PA - Projects
Description:	PA_LAUNCH_PAGE_ACTIONS_V gives the consolidated list of actions
Implementation/DBA Data:	APPS.PA_LAUNCH_PAGE_ACTIONS_V

View Text

SELECT PPE.PROJ_ELEMENT_ID
, DLVRVER.ELEMENT_VERSION_ID
, CLASS.LOOKUP_CODE
, CLASS.MEANING
, PPA.NAME
, PPA.SEGMENT1
, PPE.PROJECT_ID
, DLVR.NAME
, DLVR.ELEMENT_NUMBER
, DLVR.PROJ_ELEMENT_ID
, PPE.NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DLVR_ACTION_FUNCTION'
, PPE.FUNCTION_CODE)
, PPEVSCH.SCHEDULED_FINISH_DATE
, PPEVSCH.SCHEDULED_FINISH_DATE-TRUNC(SYSDATE)
, REQUESTOR.PARTY_NAME
, REQUESTOR.PARTY_ID
, OWNER.PARTY_NAME
, OWNER.PARTY_ID
, PPE.MANAGER_PERSON_ID
, STATUS.PROJECT_STATUS_NAME
, STATUS.PROJECT_STATUS_CODE
, STATUS.PROJECT_SYSTEM_STATUS_CODE FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_SCHEDULE PPEVSCH
, PA_PROJECTS_ALL PPA
, PA_OBJECT_RELATIONSHIPS POR
, PA_PROJ_ELEMENTS DLVR
, PA_PROJ_ELEMENT_VERSIONS DLVRVER
, HZ_PARTIES REQUESTOR
, HZ_PARTIES OWNER
, PA_PROJECT_STATUSES STATUS
, PA_LOOKUPS CLASS
WHERE PPE.OBJECT_TYPE='PA_ACTIONS'
AND DLVR.OBJECT_TYPE='PA_DELIVERABLES' AND PPEV.PROJECT_ID=PPE.PROJECT_ID AND PPEV.PROJ_ELEMENT_ID=PPE.PROJ_ELEMENT_ID AND PPEVSCH.ELEMENT_VERSION_ID=PPEV.ELEMENT_VERSION_ID AND PPA.PROJECT_ID=PPE.PROJECT_ID AND POR.OBJECT_ID_TO2=PPE.PROJ_ELEMENT_ID AND POR.OBJECT_TYPE_TO='PA_ACTIONS' AND POR.OBJECT_TYPE_FROM='PA_DELIVERABLES' AND DLVR.PROJ_ELEMENT_ID=POR.OBJECT_ID_FROM2 AND REQUESTOR.PARTY_ID(+)=PA_UTILS.GET_PARTY_ID(PPE.CREATED_BY)
AND SUBSTR(OWNER.ORIG_SYSTEM_REFERENCE
, 5)=PPE.MANAGER_PERSON_ID
AND SUBSTR(OWNER.ORIG_SYSTEM_REFERENCE
, 1
, 4) = 'PER:'
AND STATUS.STATUS_TYPE(+) ='DELIVERABLE' AND STATUS.PROJECT_STATUS_CODE(+) =PPE.STATUS_CODE
AND CLASS.LOOKUP_TYPE='PA_OBJECTS'
AND CLASS.LOOKUP_CODE='PA_DELIVERABLES'
AND DLVR.PROJ_ELEMENT_ID = DLVRVER.PROJ_ELEMENT_ID
AND POR.RELATIONSHIP_TYPE = 'A'
AND POR.RELATIONSHIP_SUBTYPE = 'DELIVERABLE_TO_ACTION'
AND NVL(PPA.TEMPLATE_FLAG
, 'N') <> 'Y'
AND POR.OBJECT_ID_TO1=PPEV.ELEMENT_VERSION_ID UNION ALL SELECT PCA.CI_ACTION_ID
, TO_NUMBER(NULL)
, PCITB.CI_TYPE_CLASS_CODE
, CLASS.MEANING
, PPA.NAME
, PPA.SEGMENT1
, PCI.PROJECT_ID
, PCITTL.SHORT_NAME
, PCI.CI_NUMBER
, PCA.CI_ID
, PCC.COMMENT_TEXT
, TYPE.MEANING
, PCA.DATE_REQUIRED
, PCA.DATE_REQUIRED-TRUNC(SYSDATE)
, REQUESTOR.PARTY_NAME
, REQUESTOR.PARTY_ID
, OWNER.PARTY_NAME
, OWNER.PARTY_ID
, TO_NUMBER(NULL)
, STATUS.PROJECT_STATUS_NAME
, STATUS.PROJECT_STATUS_CODE
, STATUS.PROJECT_SYSTEM_STATUS_CODE
FROM PA_CI_ACTIONS PCA
, PA_CI_COMMENTS PCC
, PA_CONTROL_ITEMS PCI
, PA_CI_TYPES_B PCITB
, PA_CI_TYPES_TL PCITTL
, PA_PROJECTS_ALL PPA
, HZ_PARTIES REQUESTOR
, HZ_PARTIES OWNER
, PA_PROJECT_STATUSES STATUS
, PA_LOOKUPS TYPE
, PA_LOOKUPS CLASS
WHERE PCI.CI_ID=PCA.CI_ID AND PCITTL.CI_TYPE_ID=PCI.CI_TYPE_ID
AND PCITB.CI_TYPE_ID = PCI.CI_TYPE_ID
AND PPA.PROJECT_ID=PCI.PROJECT_ID AND STATUS.STATUS_TYPE='CI_ACTION' AND STATUS.PROJECT_STATUS_CODE=PCA.STATUS_CODE AND TYPE.LOOKUP_TYPE='PA_CI_ACTION_TYPES' AND TYPE.LOOKUP_CODE=PCA.TYPE_CODE AND REQUESTOR.PARTY_ID=PA_UTILS.GET_PARTY_ID(PCA.CREATED_BY)
AND OWNER.PARTY_ID = PCA.ASSIGNED_TO
AND PCC.CI_ID=PCA.CI_ID
AND PCC.CI_ACTION_ID=PCA.CI_ACTION_ID AND PCC.TYPE_CODE='REQUESTOR' AND CLASS.LOOKUP_TYPE='PA_CI_TYPE_CLASSES' AND CLASS.LOOKUP_CODE=PCITB.CI_TYPE_CLASS_CODE
AND PCITTL.LANGUAGE = USERENV('LANG')
AND PCI.STATUS_CODE NOT IN (SELECT PROJECT_STATUS_CODE
FROM PA_PROJECT_STATUSES
WHERE STATUS_TYPE = 'CONTROL_ITEM'
AND PROJECT_SYSTEM_STATUS_CODE = 'CI_DRAFT')

Columns