View: PA_CP_GENERATE_ASSET_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_CP_GENERATE_ASSET_V

View Text

SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, L1.MEANING
, PT.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES PT
, PA_LOOKUPS L1
WHERE PP.TEMPLATE_FLAG <> 'Y'
AND PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND L1.LOOKUP_TYPE = 'GEN_ASSET_REJECTION_REASON'
AND L1.LOOKUP_CODE||'' = 'NO_ASSET_ASSIGN'
AND PT.ORG_ID= PP.ORG_ID
AND NOT EXISTS (SELECT 'X'
FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA
WHERE PPAA.PROJECT_ID = PP.PROJECT_ID) UNION SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, L1.MEANING
, PT.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES PT
, PA_LOOKUPS L1
WHERE PP.TEMPLATE_FLAG <> 'Y'
AND PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND L1.LOOKUP_TYPE = 'GEN_ASSET_REJECTION_REASON'
AND L1.LOOKUP_CODE||'' = 'NO_ELIG_COSTS'
AND PT.ORG_ID = PP.ORG_ID
AND NOT EXISTS (SELECT 'X'
FROM PA_TASKS T
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
WHERE T.PROJECT_ID = PP.PROJECT_ID
AND T.TASK_ID = EI.TASK_ID
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND CDL.BILLABLE_FLAG = 'Y' ) UNION SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, L1.MEANING
, PT.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES PT
, PA_LOOKUPS L1
WHERE PP.TEMPLATE_FLAG <> 'Y'
AND PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND L1.LOOKUP_TYPE = 'GEN_ASSET_REJECTION_REASON'
AND L1.LOOKUP_CODE||'' = 'NO_VALID_DATES'
AND PT.ORG_ID = PP.ORG_ID
AND NOT EXISTS (SELECT 'X'
FROM PA_PROJECT_ASSETS A
WHERE A.PROJECT_ID = PP.PROJECT_ID
AND A.DATE_PLACED_IN_SERVICE <= PA_FAXFACE.GET_IN_SERVICE_THRU_DATE) UNION SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, L1.MEANING
, PT.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES PT
, PA_LOOKUPS L1
WHERE PP.TEMPLATE_FLAG <> 'Y'
AND PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND L1.LOOKUP_TYPE = 'GEN_ASSET_REJECTION_REASON'
AND L1.LOOKUP_CODE||'' = 'NO_PROJ_STAT_ACTION_ALLOW'
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(PP.PROJECT_STATUS_CODE
, 'CAPITALIZE') <> 'Y'
AND PT.ORG_ID = PP.ORG_ID

Columns