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