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_MTL_SECONDARY_INV_V1

Product:	AX - Global Accounting Engine
Description:	Secondary inventory organizations by organization and cost group identifier
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASI.ORGANIZATION_ID ORGANIZATION_ID
, ASI.SECONDARY_INVENTORY_ID SECONDARY_INVENTORY_ID
, ASI.SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME
, NULL COST_GROUP_ID
FROM AX_SECONDARY_INVENTORY ASI
, MTL_PARAMETERS MP
WHERE ASI.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION SELECT CCG.ORGANIZATION_ID ORGANIZATION_ID
, 0 SECONDARY_INVENTORY_ID
, CCG.DESCRIPTION SECONDARY_INVENTORY_NAME
, TO_CHAR(CCG.COST_GROUP_ID) COST_GROUP_ID
FROM CST_COST_GROUPS CCG
, MTL_PARAMETERS MP
WHERE CCG.ORGANIZATION_ID IS NOT NULL
AND CCG.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.PRIMARY_COST_METHOD = 2 UNION SELECT MP.ORGANIZATION_ID ORGANIZATION_ID
, 0 SECONDARY_INVENTORY_ID
, CCG.DESCRIPTION SECONDARY_INVENTORY_NAME
, TO_CHAR(CCG.COST_GROUP_ID) COST_GROUP_ID
FROM CST_COST_GROUPS CCG
, MTL_PARAMETERS MP
WHERE CCG.ORGANIZATION_ID IS NULL
AND MP.PRIMARY_COST_METHOD = 2

Columns

Name
ORGANIZATION_ID
SECONDARY_INVENTORY_ID
SECONDARY_INVENTORY_NAME
COST_GROUP_ID