VIEW: APPS.PA_PROJECTS_V_PAXTRAPE

Source

View Text - Preformatted

SELECT project_number, project_name, project_id, project_type_class_code, project_status_code , org_id, operating_unit FROM pa_projects_basic_v WHERE template_flag <> 'Y' AND pa_expenditure_inquiry.get_mode = 'PROJECT' AND pa_project_stus_utils.Is_Project_In_Purge_Status(project_status_code) <> 'Y' UNION ALL SELECT p.project_number, p.project_name, p.project_id, p.project_type_class_code, p.project_status_code , p.org_id , p.operating_unit FROM pa_projects_all_basic_v p, HR_ORGANIZATION_INFORMATION PLE , PA_IMPLEMENTATIONS IMP WHERE p.template_flag <> 'Y' AND pa_expenditure_inquiry.get_mode = 'CROSS-PROJECT' AND pa_project_stus_utils.Is_Project_In_Purge_Status(p.project_status_code) <> 'Y' AND PLE.organization_id (+) = IMP.org_id AND PLE.org_information_context (+) = 'Operating Unit Information' AND ( P.org_id = imp.org_id OR P.ALLOW_CROSS_CHARGE_FLAG = 'Y' ) AND ( P.org_id = IMP.org_id OR (EXISTS (select 1 from HR_ORGANIZATION_INFORMATION RLE where RLE.org_information_context (+) = 'Operating Unit Information' AND RLE.organization_id (+) = P.org_id AND ( P.org_id = IMP.org_id OR ( PLE.org_information2 = RLE.org_information2 AND ( EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO WHERE CO.prvdr_org_id = IMP.org_id AND CO.recvr_org_id = P.org_id AND CO.prvdr_allow_cc_flag = 'Y') OR (IMP.cc_allow_iu_flag = 'Y' AND NOT EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO WHERE CO.prvdr_org_id = IMP.org_id AND CO.recvr_org_id = P.org_id AND CO.prvdr_allow_cc_flag = 'N') ) ) ) OR ( PLE.org_information2 <> RLE.org_information2 AND P.project_type_class_code <> 'CAPITAL' AND EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO WHERE CO.prvdr_org_id = IMP.org_id AND CO.recvr_org_id = P.org_id AND CO.prvdr_allow_cc_flag = 'Y' AND (( CO.prvdr_project_id IS NOT NULL AND CO.vendor_site_id IS NOT NULL AND CO.cross_charge_code = 'I') OR CO.cross_charge_code = 'N' ) ) ) ) ) ) )

View Text - HTML Formatted

SELECT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, PROJECT_TYPE_CLASS_CODE
, PROJECT_STATUS_CODE
, ORG_ID
, OPERATING_UNIT
FROM PA_PROJECTS_BASIC_V
WHERE TEMPLATE_FLAG <> 'Y'
AND PA_EXPENDITURE_INQUIRY.GET_MODE = 'PROJECT'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_IN_PURGE_STATUS(PROJECT_STATUS_CODE) <> 'Y' UNION ALL SELECT P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_ID
, P.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_STATUS_CODE
, P.ORG_ID
, P.OPERATING_UNIT
FROM PA_PROJECTS_ALL_BASIC_V P
, HR_ORGANIZATION_INFORMATION PLE
, PA_IMPLEMENTATIONS IMP
WHERE P.TEMPLATE_FLAG <> 'Y'
AND PA_EXPENDITURE_INQUIRY.GET_MODE = 'CROSS-PROJECT'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_IN_PURGE_STATUS(P.PROJECT_STATUS_CODE) <> 'Y'
AND PLE.ORGANIZATION_ID (+) = IMP.ORG_ID
AND PLE.ORG_INFORMATION_CONTEXT (+) = 'OPERATING UNIT INFORMATION'
AND ( P.ORG_ID = IMP.ORG_ID OR P.ALLOW_CROSS_CHARGE_FLAG = 'Y' )
AND ( P.ORG_ID = IMP.ORG_ID OR (EXISTS (SELECT 1
FROM HR_ORGANIZATION_INFORMATION RLE
WHERE RLE.ORG_INFORMATION_CONTEXT (+) = 'OPERATING UNIT INFORMATION'
AND RLE.ORGANIZATION_ID (+) = P.ORG_ID
AND ( P.ORG_ID = IMP.ORG_ID OR ( PLE.ORG_INFORMATION2 = RLE.ORG_INFORMATION2
AND ( EXISTS ( SELECT NULL
FROM PA_CC_ORG_RELATIONSHIPS CO
WHERE CO.PRVDR_ORG_ID = IMP.ORG_ID
AND CO.RECVR_ORG_ID = P.ORG_ID
AND CO.PRVDR_ALLOW_CC_FLAG = 'Y') OR (IMP.CC_ALLOW_IU_FLAG = 'Y'
AND NOT EXISTS ( SELECT NULL
FROM PA_CC_ORG_RELATIONSHIPS CO
WHERE CO.PRVDR_ORG_ID = IMP.ORG_ID
AND CO.RECVR_ORG_ID = P.ORG_ID
AND CO.PRVDR_ALLOW_CC_FLAG = 'N') ) ) ) OR ( PLE.ORG_INFORMATION2 <> RLE.ORG_INFORMATION2
AND P.PROJECT_TYPE_CLASS_CODE <> 'CAPITAL'
AND EXISTS ( SELECT NULL
FROM PA_CC_ORG_RELATIONSHIPS CO
WHERE CO.PRVDR_ORG_ID = IMP.ORG_ID
AND CO.RECVR_ORG_ID = P.ORG_ID
AND CO.PRVDR_ALLOW_CC_FLAG = 'Y'
AND (( CO.PRVDR_PROJECT_ID IS NOT NULL
AND CO.VENDOR_SITE_ID IS NOT NULL
AND CO.CROSS_CHARGE_CODE = 'I') OR CO.CROSS_CHARGE_CODE = 'N' ) ) ) ) ) ) )