VIEW: APPS.PA_PROJECTS_ALL_EXPEND_V

Source

View Text - Preformatted

SELECT P.project_id, P.segment1, P.name, P.description, P.project_type, P.carrying_out_organization_id, PT.project_type_class_code, P.project_status_code, NVL(P.template_flag, 'N'), P.pm_project_reference, P.segment1, P.org_id, P.start_date, P.completion_date, P.project_currency_code, P.allow_cross_charge_flag, P.project_rate_date, P.project_rate_type, imp.cc_allow_iu_flag, hr.name, imp.org_id, pt.cc_prvdr_flag, iall.set_of_books_id, imp.set_of_books_id FROM pa_project_types_all PT, pa_projects_all P, HR_ORGANIZATION_INFORMATION PLE, HR_ORGANIZATION_INFORMATION RLE, HR_ALL_ORGANIZATION_UNITS HR, pa_implementations_all imp, pa_implementations_all iall WHERE P.project_type = PT.project_type AND PT.org_id = P.org_id AND PA_PROJECT_UTILS.check_prj_stus_action_allowed(P.project_status_code, 'NEW_TXNS') = 'Y' AND pt.cc_prvdr_flag <> 'Y' AND NVL(P.template_flag, 'N') <> 'Y' AND pa_security.allow_query(P.project_id) = 'Y' AND imp.org_id = hr.organization_id AND ((imp.business_group_id = iall.business_group_id and FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='N') OR FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') ='Y') AND iall.org_id = P.org_id AND PT.project_type <> 'AWARD_PROJECT' AND PLE.organization_id = imp.org_id AND PLE.org_information_context = 'Operating Unit Information' AND RLE.organization_id = iall.org_id AND RLE.org_information_context = 'Operating Unit Information' AND ( imp.org_id= iall.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 = iall.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 = iall.org_id AND CO.prvdr_allow_cc_flag = 'N') ) ) ) OR ( PLE.org_information2 <> RLE.org_information2 AND pt.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 = iall.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' ) ) ) ) AND ( iall.org_id= imp.org_id OR P.ALLOW_CROSS_CHARGE_FLAG = 'Y' )

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.DESCRIPTION
, P.PROJECT_TYPE
, P.CARRYING_OUT_ORGANIZATION_ID
, PT.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_STATUS_CODE
, NVL(P.TEMPLATE_FLAG
, 'N')
, P.PM_PROJECT_REFERENCE
, P.SEGMENT1
, P.ORG_ID
, P.START_DATE
, P.COMPLETION_DATE
, P.PROJECT_CURRENCY_CODE
, P.ALLOW_CROSS_CHARGE_FLAG
, P.PROJECT_RATE_DATE
, P.PROJECT_RATE_TYPE
, IMP.CC_ALLOW_IU_FLAG
, HR.NAME
, IMP.ORG_ID
, PT.CC_PRVDR_FLAG
, IALL.SET_OF_BOOKS_ID
, IMP.SET_OF_BOOKS_ID
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, HR_ORGANIZATION_INFORMATION PLE
, HR_ORGANIZATION_INFORMATION RLE
, HR_ALL_ORGANIZATION_UNITS HR
, PA_IMPLEMENTATIONS_ALL IMP
, PA_IMPLEMENTATIONS_ALL IALL
WHERE P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(P.PROJECT_STATUS_CODE
, 'NEW_TXNS') = 'Y'
AND PT.CC_PRVDR_FLAG <> 'Y'
AND NVL(P.TEMPLATE_FLAG
, 'N') <> 'Y'
AND PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID) = 'Y'
AND IMP.ORG_ID = HR.ORGANIZATION_ID
AND ((IMP.BUSINESS_GROUP_ID = IALL.BUSINESS_GROUP_ID
AND FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='N') OR FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') ='Y')
AND IALL.ORG_ID = P.ORG_ID
AND PT.PROJECT_TYPE <> 'AWARD_PROJECT'
AND PLE.ORGANIZATION_ID = IMP.ORG_ID
AND PLE.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND RLE.ORGANIZATION_ID = IALL.ORG_ID
AND RLE.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND ( IMP.ORG_ID= IALL.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 = IALL.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 = IALL.ORG_ID
AND CO.PRVDR_ALLOW_CC_FLAG = 'N') ) ) ) OR ( PLE.ORG_INFORMATION2 <> RLE.ORG_INFORMATION2
AND PT.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 = IALL.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' ) ) ) )
AND ( IALL.ORG_ID= IMP.ORG_ID OR P.ALLOW_CROSS_CHARGE_FLAG = 'Y' )