View: AS_OPPORTUNITY_OBSTACLES_V

Product:	AS - Sales Foundation
Description:	View to provide details about opportunity issues.
Implementation/DBA Data:	APPS.AS_OPPORTUNITY_OBSTACLES_V

View Text

SELECT OPPOBS.ROWID ROW_ID
, OPPOBS.LEAD_OBSTACLE_ID
, OPPOBS.LAST_UPDATE_DATE
, OPPOBS.LAST_UPDATED_BY
, OPPOBS.CREATION_DATE
, OPPOBS.CREATED_BY
, OPPOBS.LAST_UPDATE_LOGIN
, OPPOBS.REQUEST_ID
, OPPOBS.PROGRAM_APPLICATION_ID
, OPPOBS.PROGRAM_ID
, OPPOBS.PROGRAM_UPDATE_DATE
, OPPOBS.LEAD_ID
, OPPOBS.OBSTACLE_CODE
, OPPOBS.OBSTACLE
, ASL.MEANING OBSTACLE_MEANING
, OPPOBS.OBSTACLE_STATUS
, OPPOBS.COMMENTS
, OPPOBS.ATTRIBUTE_CATEGORY
, OPPOBS.ATTRIBUTE1
, OPPOBS.ATTRIBUTE2
, OPPOBS.ATTRIBUTE3
, OPPOBS.ATTRIBUTE4
, OPPOBS.ATTRIBUTE5
, OPPOBS.ATTRIBUTE6
, OPPOBS.ATTRIBUTE7
, OPPOBS.ATTRIBUTE8
, OPPOBS.ATTRIBUTE9
, OPPOBS.ATTRIBUTE10
, OPPOBS.ATTRIBUTE11
, OPPOBS.ATTRIBUTE12
, OPPOBS.ATTRIBUTE13
, OPPOBS.ATTRIBUTE14
, OPPOBS.ATTRIBUTE15
FROM AS_LEAD_OBSTACLES OPPOBS
, AS_LOOKUPS ASL
WHERE OPPOBS.OBSTACLE_CODE = ASL.LOOKUP_CODE (+)
AND ASL.LOOKUP_TYPE (+) = 'ISSUE'

Columns