VIEW: APPS.AS_OPPORTUNITY_OBSTACLES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'