VIEW: APPS.AZ_PRODUCT_PHASES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'