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: XNC_MODLIST_ITEM_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	XNC_MODLIST_ITEM_V retrieves adjustments or discounts available for an Inventory Item.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROW_ID
, A.LIST_HEADER_ID
, A.NAME
, A.LIST_TYPE_CODE
, A.CURRENCY_CODE
, A.QPH_START_DATE_ACTIVE
, A.QPH_END_DATE_ACTIVE
, A.DESCRIPTION
, A.GSA_INDICATOR
, A.PRORATE_FLAG
, A.SOURCE_SYSTEM_CODE
, A.LIST_LINE_ID
, A.LIST_LINE_TYPE_CODE
, A.AUTOMATIC_FLAG
, A.MODIFIER_LEVEL_CODE
, A.LIST_PRICE
, A.PERCENT_PRICE
, A.ARITHMETIC_OPERATOR
, A.OPERAND
, A.OVERRIDE_FLAG
, A.PRINT_ON_INVOICE_FLAG
, A.PRODUCT_ATTRIBUTE_CONTEXT
, A.PRODUCT_ATTRIBUTE
, TO_NUMBER (A.PRODUCT_ATTR_VALUE)
, M.ORGANIZATION_ID
, M.PADDED_CONCATENATED_SEGMENTS
, A.PRODUCT_UOM_CODE
FROM QP_LIST_ATTRIBUTES_V A
, MTL_SYSTEM_ITEMS_KFV M
, MTL_PARAMETERS_VIEW MP
WHERE A.LIST_TYPE_CODE != 'PRL' AND A.LIST_LINE_TYPE_CODE != 'PLL' AND TO_NUMBER(A.PRODUCT_ATTR_VALUE) = M.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = M.ORGANIZATION_ID

Columns

Name
ROW_ID
MODIFIER_LIST_ID
NAME
MODIFIER_LIST_TYPE
CURRENCY_CODE
START_DATE_ACTIVE
END_DATE_ACTIVE
DESCRIPTION
GSA_INDICATOR
PRORATE_FLAG
SOURCE_SYSTEM_CODE
MOD_LIST_LINE_ID
LIST_LINE_TYPE_CODE
AUTOMATIC_FLAG
MODIFIER_LEVEL_CODE
LIST_PRICE
PERCENT_PRICE
ARITHMETIC_OPERATOR
OPERAND
OVERRIDE_FLAG
PRINT_ON_INVOICE_FLAG
PRODUCT_ATTRIBUTE_CONTEXT
PRODUCT_ATTRIBUTE
ITEM_ID
ORGANIZATION_ID
ITEM_NAME
PRODUCT_UOM_CODE