VIEW: APPS.PA_RELATED_ITEMS_V

Source

View Text - Preformatted

SELECT ci.project_id ,ppa.name || '(' || ppa.segment1 || ')' ,ci.ci_id ,ci.ci_number ,citypeb.ci_type_id ,ci.summary ,ci.status_code ,status.project_status_name ,status.project_system_status_code ,ci.owner_id ,owner.party_name ,ci.object_type ,ci.object_id ,DECODE(ci.object_type, NULL, NULL, pa_proj_elements_utils.get_element_name(ci.object_id)) ,classification.class_code ,reason.class_code ,citypeb.ci_type_class_code ,citypetl.name ,citypetl.short_name ,citypetl.short_name || '(' || ci.ci_number || ')' ,ci.record_version_number FROM pa_ci_types_b citypeb ,pa_ci_types_tl citypetl ,pa_control_items ci ,pa_projects_all ppa ,pa_project_statuses status ,hz_parties owner ,pa_class_codes reason ,pa_class_codes classification WHERE ci.ci_type_id = citypeb.ci_type_id AND pa_ci_security_pkg.check_view_access(ci_id) = 'T' AND citypetl.ci_type_id = citypeb.ci_type_id AND citypetl.language = USERENV('LANG') AND ppa.project_id = ci.project_id AND status.project_status_code = ci.status_code AND status.status_type = 'CONTROL_ITEM' AND owner.party_id = ci.owner_id AND reason.class_code_id(+) = ci.reason_code_id AND classification.class_code_id(+) = ci.classification_code_id

View Text - HTML Formatted

SELECT CI.PROJECT_ID
, PPA.NAME || '(' || PPA.SEGMENT1 || ')'
, CI.CI_ID
, CI.CI_NUMBER
, CITYPEB.CI_TYPE_ID
, CI.SUMMARY
, CI.STATUS_CODE
, STATUS.PROJECT_STATUS_NAME
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, CI.OWNER_ID
, OWNER.PARTY_NAME
, CI.OBJECT_TYPE
, CI.OBJECT_ID
, DECODE(CI.OBJECT_TYPE
, NULL
, NULL
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NAME(CI.OBJECT_ID))
, CLASSIFICATION.CLASS_CODE
, REASON.CLASS_CODE
, CITYPEB.CI_TYPE_CLASS_CODE
, CITYPETL.NAME
, CITYPETL.SHORT_NAME
, CITYPETL.SHORT_NAME || '(' || CI.CI_NUMBER || ')'
, CI.RECORD_VERSION_NUMBER
FROM PA_CI_TYPES_B CITYPEB
, PA_CI_TYPES_TL CITYPETL
, PA_CONTROL_ITEMS CI
, PA_PROJECTS_ALL PPA
, PA_PROJECT_STATUSES STATUS
, HZ_PARTIES OWNER
, PA_CLASS_CODES REASON
, PA_CLASS_CODES CLASSIFICATION
WHERE CI.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND PA_CI_SECURITY_PKG.CHECK_VIEW_ACCESS(CI_ID) = 'T'
AND CITYPETL.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND CITYPETL.LANGUAGE = USERENV('LANG')
AND PPA.PROJECT_ID = CI.PROJECT_ID
AND STATUS.PROJECT_STATUS_CODE = CI.STATUS_CODE
AND STATUS.STATUS_TYPE = 'CONTROL_ITEM'
AND OWNER.PARTY_ID = CI.OWNER_ID
AND REASON.CLASS_CODE_ID(+) = CI.REASON_CODE_ID
AND CLASSIFICATION.CLASS_CODE_ID(+) = CI.CLASSIFICATION_CODE_ID