VIEW: APPS.AS_OPPORTUNITY_COMPETITORS_V

Source

View Text - Preformatted

SELECT ASLCOMP.ROWID ROW_ID, ASLCOMP.LEAD_COMPETITOR_ID, ASLCOMP.LAST_UPDATE_DATE, ASLCOMP.LAST_UPDATED_BY, ASLCOMP.CREATION_DATE, ASLCOMP.CREATED_BY, ASLCOMP.LAST_UPDATE_LOGIN, ASLCOMP.REQUEST_ID, ASLCOMP.PROGRAM_APPLICATION_ID, ASLCOMP.PROGRAM_ID, ASLCOMP.PROGRAM_UPDATE_DATE, ASLCOMP.LEAD_ID, ASLCOMP.PRODUCTS, ASLCOMP.COMMENTS, ASLCOMP.ATTRIBUTE_CATEGORY, ASLCOMP.ATTRIBUTE1, ASLCOMP.ATTRIBUTE2, ASLCOMP.ATTRIBUTE3, ASLCOMP.ATTRIBUTE4, ASLCOMP.ATTRIBUTE5, ASLCOMP.ATTRIBUTE6, ASLCOMP.ATTRIBUTE7, ASLCOMP.ATTRIBUTE8, ASLCOMP.ATTRIBUTE9, ASLCOMP.ATTRIBUTE10, ASLCOMP.ATTRIBUTE11, ASLCOMP.ATTRIBUTE12, ASLCOMP.ATTRIBUTE13, ASLCOMP.ATTRIBUTE14, ASLCOMP.ATTRIBUTE15, ASLCOMP.COMPETITOR_ID, ASLCOMP.COMPETITOR_RANK, PARTY.PARTY_NAME CUSTOMER_NAME, ASLCOMP.WIN_LOSS_STATUS, ASLCOMP.RELATIONSHIP_PARTY_ID FROM AS_LEAD_COMPETITORS ASLCOMP, HZ_PARTIES PARTY WHERE ASLCOMP.COMPETITOR_ID = PARTY.PARTY_ID

View Text - HTML Formatted

SELECT ASLCOMP.ROWID ROW_ID
, ASLCOMP.LEAD_COMPETITOR_ID
, ASLCOMP.LAST_UPDATE_DATE
, ASLCOMP.LAST_UPDATED_BY
, ASLCOMP.CREATION_DATE
, ASLCOMP.CREATED_BY
, ASLCOMP.LAST_UPDATE_LOGIN
, ASLCOMP.REQUEST_ID
, ASLCOMP.PROGRAM_APPLICATION_ID
, ASLCOMP.PROGRAM_ID
, ASLCOMP.PROGRAM_UPDATE_DATE
, ASLCOMP.LEAD_ID
, ASLCOMP.PRODUCTS
, ASLCOMP.COMMENTS
, ASLCOMP.ATTRIBUTE_CATEGORY
, ASLCOMP.ATTRIBUTE1
, ASLCOMP.ATTRIBUTE2
, ASLCOMP.ATTRIBUTE3
, ASLCOMP.ATTRIBUTE4
, ASLCOMP.ATTRIBUTE5
, ASLCOMP.ATTRIBUTE6
, ASLCOMP.ATTRIBUTE7
, ASLCOMP.ATTRIBUTE8
, ASLCOMP.ATTRIBUTE9
, ASLCOMP.ATTRIBUTE10
, ASLCOMP.ATTRIBUTE11
, ASLCOMP.ATTRIBUTE12
, ASLCOMP.ATTRIBUTE13
, ASLCOMP.ATTRIBUTE14
, ASLCOMP.ATTRIBUTE15
, ASLCOMP.COMPETITOR_ID
, ASLCOMP.COMPETITOR_RANK
, PARTY.PARTY_NAME CUSTOMER_NAME
, ASLCOMP.WIN_LOSS_STATUS
, ASLCOMP.RELATIONSHIP_PARTY_ID
FROM AS_LEAD_COMPETITORS ASLCOMP
, HZ_PARTIES PARTY
WHERE ASLCOMP.COMPETITOR_ID = PARTY.PARTY_ID