VIEW: APPS.PA_PROJ_ALL_BASIC_UN_SEC_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, PA_PROJECT_UTILS.check_prj_stus_action_allowed(P.project_status_code, 'NEW_TXNS'), pt.cc_prvdr_flag, iall.set_of_books_id, P.projfunc_currency_code, P.projfunc_cost_rate_date, P.projfunc_cost_rate_type, HR.name FROM pa_project_types_all PT, pa_projects_all P, pa_implementations_all iall, hr_all_organization_units HR WHERE P.project_type = PT.project_type AND NVL(P.template_flag, 'N') <> 'Y' AND ((iall.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') and pa_cross_business_grp.IsCrossBGProfile='N' ) OR pa_cross_business_grp.IsCrossBGProfile ='Y') AND iall.org_id = P.org_id AND PT.org_id = P.org_id AND PT.project_type <> 'AWARD_PROJECT' AND HR.organization_id = PT.org_id

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
, PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(P.PROJECT_STATUS_CODE
, 'NEW_TXNS')
, PT.CC_PRVDR_FLAG
, IALL.SET_OF_BOOKS_ID
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_COST_RATE_DATE
, P.PROJFUNC_COST_RATE_TYPE
, HR.NAME
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS_ALL IALL
, HR_ALL_ORGANIZATION_UNITS HR
WHERE P.PROJECT_TYPE = PT.PROJECT_TYPE
AND NVL(P.TEMPLATE_FLAG
, 'N') <> 'Y'
AND ((IALL.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N' ) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')
AND IALL.ORG_ID = P.ORG_ID
AND PT.ORG_ID = P.ORG_ID
AND PT.PROJECT_TYPE <> 'AWARD_PROJECT'
AND HR.ORGANIZATION_ID = PT.ORG_ID