View: AZ_PRODUCT_PHASES_V

Product:	AZ - Application Implementation
Description:	Stores language-dependent application names along with their phase information
Implementation/DBA Data:	APPS.AZ_PRODUCT_PHASES_V

View Text

SELECT APP.APPLICATION_ID
, FAV.APPLICATION_NAME
, FAV.APPLICATION_SHORT_NAME
, APP.PHASE
FROM AZ_PRODUCT_PHASES APP
, FND_APPLICATION_VL FAV
, FND_PRODUCT_INSTALLATIONS FPI
, AZ_GROUPS AZG
WHERE APP.APPLICATION_ID = FAV.APPLICATION_ID
AND FAV.APPLICATION_ID = FPI.APPLICATION_ID
AND FPI.STATUS = 'I'
AND FPI.APPLICATION_ID = AZG.APPLICATION_ID
AND AZG.PROCESS_TYPE = 'IMP'

Columns