[Home] [Help]
View: AS_COLLATERAL_ACTIVE_V
Product: | AS - Sales Foundation |
Description: | Active collateral pieces view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT P.PROMOTION_ID
, P.CODE
, P.NAME
, P.DESCRIPTION
, P.COLLATERAL_INVENTORY_ITEM_ID
, P.COLLATERAL_ORGANIZATION_ID
, P.STATUS
FROM AS_PROMOTIONS P
WHERE P.TYPE = 'C'
AND P.ENABLED_FLAG = 'Y'
Columns
Name |
COLLATERAL_ID |
CODE |
NAME |
DESCRIPTION |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
STATUS_CODE |