View: PA_CP_GENERATE_ASSET_BASE_V

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

View Text

SELECT PP.SEGMENT1
, PP.NAME
, NVL(PPA.ASSET_NAME
, L.MEANING)
, PPAL.REQUEST_ID
, 0
, 0
, COUNT(PPAL.PROJECT_ASSET_LINE_ID) GENERATE_LINES
, SUM(PPAL.CURRENT_ASSET_COST) GENERATE_AMOUNT
, PP.PROJECT_CURRENCY_CODE
, PPAL.LINE_TYPE
, PPAL.RETIREMENT_COST_TYPE
, PP.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_ASSETS_ALL PPA
, PA_PROJECT_ASSET_LINES_ALL PPAL
, PA_LOOKUPS L
WHERE PPAL.PROJECT_ASSET_ID = PPA.PROJECT_ASSET_ID(+)
AND PPAL.PROJECT_ID = PP.PROJECT_ID
AND PPAL.REV_PROJ_ASSET_LINE_ID IS NULL
AND L.LOOKUP_TYPE ='UNASSIGNED ASSET'
AND L.LOOKUP_CODE||'' ='UNASSIGNED'
AND ((MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL
AND MO_GLOBAL.CHECK_ACCESS(PP.ORG_ID) = 'Y') OR ( MO_GLOBAL.GET_CURRENT_ORG_ID IS NOT NULL
AND PP.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID )) GROUP BY PP.SEGMENT1
, PP.NAME
, NVL( PPA.ASSET_NAME
, L.MEANING)
, PPAL.REQUEST_ID
, PP.PROJECT_CURRENCY_CODE
, PPAL.LINE_TYPE
, PPAL.RETIREMENT_COST_TYPE
, PP.ORG_ID UNION SELECT PP.SEGMENT1
, PP.NAME
, NVL(PPA.ASSET_NAME
, L.MEANING)
, PPAL.REQUEST_ID
, COUNT(PPAL.PROJECT_ASSET_LINE_ID) REVERSE_LINES
, SUM(PPAL.CURRENT_ASSET_COST) REVERSE_AMOUNT
, 0
, 0
, PP.PROJECT_CURRENCY_CODE
, PPAL.LINE_TYPE
, PPAL.RETIREMENT_COST_TYPE
, PP.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_ASSETS_ALL PPA
, PA_PROJECT_ASSET_LINES_ALL PPAL
, PA_LOOKUPS L
WHERE PPAL.PROJECT_ASSET_ID = PPA.PROJECT_ASSET_ID(+)
AND PPAL.PROJECT_ID = PP.PROJECT_ID
AND PPAL.REV_PROJ_ASSET_LINE_ID IS NOT NULL
AND PPAL.TRANSFER_STATUS_CODE <> 'R'
AND L.LOOKUP_TYPE ='UNASSIGNED ASSET'
AND L.LOOKUP_CODE||'' ='UNASSIGNED'
AND ((MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL
AND MO_GLOBAL.CHECK_ACCESS(PP.ORG_ID) = 'Y') OR ( MO_GLOBAL.GET_CURRENT_ORG_ID IS NOT NULL
AND PP.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID )) GROUP BY PP.SEGMENT1
, PP.NAME
, NVL( PPA.ASSET_NAME
, L.MEANING)
, PPAL.REQUEST_ID
, PP.PROJECT_CURRENCY_CODE
, PPAL.LINE_TYPE
, PPAL.RETIREMENT_COST_TYPE
, PP.ORG_ID

Columns