Product: | AS - Sales Foundation |
---|---|
Description: | View based on hz_parties and as_lead_competitors |
Implementation/DBA Data: | APPS.AS_OPPORTUNITY_COMPETITORS_V |
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