View: PA_PROJECTS_EXPEND_V

Product:	PA - Projects
Description:	View of the projects to which you can charge expenditures
Implementation/DBA Data:	APPS.PA_PROJECTS_EXPEND_V

View Text

SELECT P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.START_DATE
, P.COMPLETION_DATE
, P.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_NUMBER_SORT_ORDER
, P.PROJECT_TYPE
, P.CARRYING_OUT_ORGANIZATION_ID
, P.PROJECT_CURRENCY_CODE
, P.ALLOW_CROSS_CHARGE_FLAG
, P.PROJECT_RATE_DATE
, P.PROJECT_RATE_TYPE
, P.ORG_ID
, IMP.ORG_ID EXPENDITURE_ORG_ID
, P.PROJFUNC_CURRENCY_CODE
, P.PROJFUNC_COST_RATE_DATE
, P.PROJFUNC_COST_RATE_TYPE
, P.PROJECT_STATUS_CODE
, P.OPERATING_UNIT
FROM HR_ORGANIZATION_INFORMATION PLE
, PA_PROJ_ALL_BASIC_UN_SEC_V P
, PA_IMPLEMENTATIONS IMP
WHERE P.CHARGES_ALLOWED_FLAG = 'Y'
AND NVL(P.CC_PRVDR_FLAG
, 'N') <> 'Y'
AND (P.PROJ_SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID OR EXISTS (SELECT 1
FROM PA_BUDGETARY_CONTROL_OPTIONS BC
, PA_PROJECTS_ALL PA
WHERE BC.PROJECT_ID(+) = PA.PROJECT_ID
AND PA.PROJECT_ID = P.PROJECT_ID
AND NVL(BC.BDGT_CNTRL_FLAG
, 'N') = 'N') )
AND PLE.ORGANIZATION_ID (+) = IMP.ORG_ID
AND PLE.ORG_INFORMATION_CONTEXT (+) = 'OPERATING UNIT INFORMATION'
AND ( P.ORG_ID = IMP.ORG_ID OR P.ALLOW_CROSS_CHARGE_FLAG = 'Y' )
AND ( P.ORG_ID = IMP.ORG_ID OR (EXISTS (SELECT 1
FROM HR_ORGANIZATION_INFORMATION RLE
WHERE RLE.ORG_INFORMATION_CONTEXT (+) = 'OPERATING UNIT INFORMATION'
AND RLE.ORGANIZATION_ID (+) = P.ORG_ID
AND ( P.ORG_ID = IMP.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 = P.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 = P.ORG_ID
AND CO.PRVDR_ALLOW_CC_FLAG = 'N') ) ) ) OR ( PLE.ORG_INFORMATION2 <> RLE.ORG_INFORMATION2
AND P.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 = P.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' ) ) ) ) ) ) )

Columns