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

Product:	AX - Global Accounting Engine
Description:	Layer IDs of cost groups or subinventory
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MSI.ORGANIZATION_ID ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, AMSI.COST_GROUP_ID COST_GROUP_ID
, AMSI.SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME
, TO_NUMBER('-1') LAYER_ID
FROM AX_MTL_SECONDARY_INV_V1 AMSI
, MTL_SYSTEM_ITEMS MSI
WHERE MSI.ORGANIZATION_ID = AMSI.ORGANIZATION_ID AND AMSI.COST_GROUP_ID IS NULL UNION SELECT CQL.ORGANIZATION_ID ORGANIZATION_ID
, CQL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, AMSI.COST_GROUP_ID COST_GROUP_ID
, AMSI.SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME
, CQL.LAYER_ID LAYER_ID
FROM AX_MTL_SECONDARY_INV_V1 AMSI
, CST_QUANTITY_LAYERS CQL
WHERE AMSI.COST_GROUP_ID IS NOT NULL AND CQL.ORGANIZATION_ID = AMSI.ORGANIZATION_ID AND CQL.COST_GROUP_ID = AMSI.COST_GROUP_ID

Columns

Name
ORGANIZATION_ID
INVENTORY_ITEM_ID
COST_GROUP_ID
SECONDARY_INVENTORY_NAME
LAYER_ID