Product: | PA - Projects |
---|---|
Description: | View of the projects to which you can do search. (For subledgers LOV) |
Implementation/DBA Data: | APPS.PA_PROJ_ALL_BASIC_UN_SEC_V |
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