[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 |