View: SO_SALES_CREDITS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_SALES_CREDITS_V

View Text

SELECT SSC.ROWID ROW_ID
, SSC.SALES_CREDIT_ID
, RS.NAME SALESPERSON
, SCT.NAME SALES_CREDIT_TYPE
, NVL(SCT.QUOTA_FLAG
, 'N') REVENUE_FLAG
, SSC.PERCENT PERCENT
, SSC.SALES_CREDIT_TYPE_ID
, SSC.HEADER_ID
, SSC.LINE_ID
, SSC.SALESREP_ID
, SSC.CREATION_DATE
, SSC.CREATED_BY
, SSC.LAST_UPDATE_DATE
, SSC.LAST_UPDATED_BY
, SSC.LAST_UPDATE_LOGIN
, SSC.CONTEXT
, SSC.ATTRIBUTE1
, SSC.ATTRIBUTE2
, SSC.ATTRIBUTE3
, SSC.ATTRIBUTE4
, SSC.ATTRIBUTE5
, SSC.ATTRIBUTE6
, SSC.ATTRIBUTE7
, SSC.ATTRIBUTE8
, SSC.ATTRIBUTE9
, SSC.ATTRIBUTE10
, SSC.ATTRIBUTE11
, SSC.ATTRIBUTE12
, SSC.ATTRIBUTE13
, SSC.ATTRIBUTE14
, SSC.ATTRIBUTE15
FROM SO_SALES_CREDITS SSC
, RA_SALESREPS RS
, SO_SALES_CREDIT_TYPES SCT
WHERE RS.SALESREP_ID(+) = SSC.SALESREP_ID
AND SCT.SALES_CREDIT_TYPE_ID(+) = SSC.SALES_CREDIT_TYPE_ID

Columns