VIEW: APPS.PA_ALLOC_TARGET_PROJ_V

Source

View Text - Preformatted

SELECT P.PROJECT_ID , P.SEGMENT1 , P.NAME , P.DESCRIPTION , P.START_DATE , P.COMPLETION_DATE , PT.PROJECT_TYPE_CLASS_CODE , P.SEGMENT1 , P.PROJECT_TYPE , P.CARRYING_OUT_ORGANIZATION_ID , ORG.NAME , PPC.CLASS_CATEGORY , PPC.CLASS_CODE , P.project_currency_code , P.allow_cross_charge_flag , P.project_rate_date , P.project_rate_type , pcou.prvdr_legal_entity_id , pcou.recvr_legal_entity_id , pcou.prvdr_org_id , pcou.recvr_org_id , pcou.BUSINESS_GROUP_ID , pcou.RECVR_BUSINESS_GROUP_ID FROM PA_PROJECT_TYPES_ALL PT , PA_PROJECTS_ALL P , pa_cross_chargeable_OU_V pcou , hr_organization_units org , pa_project_classes ppc WHERE P.PROJECT_TYPE = PT.PROJECT_TYPE AND PPC.PROJECT_ID(+) = P.PROJECT_ID AND P.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID AND NVL(P.TEMPLATE_FLAG, 'N') <> 'Y' AND (pcou.prvdr_org_id is null OR pcou.recvr_org_id = p.org_id) AND (pt.org_id is NULL OR pt.org_id = p.org_id) AND pa_project_utils.Check_prj_stus_action_allowed (p.project_status_code, 'NEW_TXNS') = 'Y'

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.DESCRIPTION
, P.START_DATE
, P.COMPLETION_DATE
, PT.PROJECT_TYPE_CLASS_CODE
, P.SEGMENT1
, P.PROJECT_TYPE
, P.CARRYING_OUT_ORGANIZATION_ID
, ORG.NAME
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, P.PROJECT_CURRENCY_CODE
, P.ALLOW_CROSS_CHARGE_FLAG
, P.PROJECT_RATE_DATE
, P.PROJECT_RATE_TYPE
, PCOU.PRVDR_LEGAL_ENTITY_ID
, PCOU.RECVR_LEGAL_ENTITY_ID
, PCOU.PRVDR_ORG_ID
, PCOU.RECVR_ORG_ID
, PCOU.BUSINESS_GROUP_ID
, PCOU.RECVR_BUSINESS_GROUP_ID
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, PA_CROSS_CHARGEABLE_OU_V PCOU
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_CLASSES PPC
WHERE P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PPC.PROJECT_ID(+) = P.PROJECT_ID
AND P.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND NVL(P.TEMPLATE_FLAG
, 'N') <> 'Y'
AND (PCOU.PRVDR_ORG_ID IS NULL OR PCOU.RECVR_ORG_ID = P.ORG_ID)
AND (PT.ORG_ID IS NULL OR PT.ORG_ID = P.ORG_ID)
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (P.PROJECT_STATUS_CODE
, 'NEW_TXNS') = 'Y'