View: PA_PROJECTS_ALL_EXPEND_V

Product:	PA - Projects
Description:	View of the projects to which you can do search. (For subledgers LOV)
Implementation/DBA Data:	APPS.PA_PROJECTS_ALL_EXPEND_V

View Text

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' )

Columns