[Home] [Help]
| Product: | XNC - Sales for Communications (Obsolete) |
|---|---|
| Description: | This view is intended to provide the various action,sub action, sequence, parameters and other values related to a Product , which is the join of XNC_ITEM_PARS_VL and XNC_ITEM_ACTIONS_V |
| Implementation/DBA Data: | Not implemented in this database |
SELECT B.ROW_ID ROW_ID
, B.ITEM_ACTION_PARAM_ID
, B.ITEM_ACTION_ID
, B.PARAMETER_NAME
, B.PARAMETER_MEANING
, C.INVENTORY_ITEM_ID
, C.ORGANIZATION_ID
, C.ACTION_TYPE
, C.SUB_ACTION_TYPE
, C.ACTION_NAME
, C.ITEM_NAME
, C.ITEM_DESCRIPTION
, C.ACTION_DESCRIPTION
, C.SYNCHRONOUS_ACTION_FLAG
, B.MANDATORY_FLAG
, B.DEFAULT_VALUE
, B.DISPLAY_FLAG
, B.SEQUENCE
, B.SYSTEM_DEFINED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.PARAMETER_DESCRIPTION
, B.DISPLAY_MEANING
, B.SOURCE_TYPE_CODE
, B.SOURCE_TYPE_MEANING
, B.SOURCE_NAME
, B.SOURCE_MEANING
, B.INSTALL_BASE_FLAG
, B.SUBSCRIPTION_FLAG
, B.USER_INSTRUCTION
, B.PARAMETER_SYNCHRONOUS_FLAG
FROM XNC_ITEM_ACTION_PARS_VL B
, XNC_ITEM_ACTIONS_V C
WHERE B.ITEM_ACTION_ID = C.ITEM_ACTION_ID