View: PA_ALLOC_TARGET_PROJ_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ALLOC_TARGET_PROJ_V

View Text

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'

Columns