eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AS_COLLATERAL_CATEGORIES_NEW_V

Product:	AS - Sales Foundation
Description:	Collateral categories
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CC.ROWID
, CC.PROMOTION_ID
, PROM.CODE
, PROM.NAME
, PROM.COLLATERAL_INVENTORY_ITEM_ID
, PROM.COLLATERAL_ORGANIZATION_ID
, PROM.COLLATERAL_CHARGEBACK_AMT
, PROM.ENABLED_FLAG
, PROM.PUBLIC_FLAG
, PROM.OWNER_PERSON_ID
, PROM.COLLATERAL_KIT_FLAG
, PROM.STATUS
, ASLKP.MEANING
, PROM.DESCRIPTION
, CC.CATEGORY_ID
, CAT.NAME
, CAT.DESCRIPTION
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
, CC.CREATION_DATE
, CC.CREATED_BY
, CC.LAST_UPDATE_LOGIN
, CC.REQUEST_ID
, CC.PROGRAM_APPLICATION_ID
, CC.PROGRAM_ID
, CC.PROGRAM_UPDATE_DATE
FROM AS_CATEGORIES CAT
, AS_LOOKUPS ASLKP
, AS_PROMOTIONS PROM
, AS_COLLATERAL_CAT CC
WHERE CC.PROMOTION_ID = PROM.PROMOTION_ID
AND ASLKP.LOOKUP_TYPE(+) = 'COLLATERAL_STATUS'
AND ASLKP.LOOKUP_CODE(+) = PROM.STATUS
AND CAT.CATEGORY_ID(+) = CC.CATEGORY_ID

Columns

Name
ROW_ID
COLLATERAL_ID
COLLATERAL_CODE
COLLATERAL_NAME
INVENTORY_ITEM_ID
ORGANIZATION_ID
CHARGEBACK_AMT
ENABLED_FLAG
PUBLIC_FLAG
OWNER_PERSON_ID
COLLATERAL_KIT_FLAG
STATUS_CODE
STATUS
DESCRIPTION
CATEGORY_ID
CATEGORY_NAME
CATEGORY_DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE