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_CATEGORY_ACCOUNTS_V1

Product:	AX - Global Accounting Engine
Description:	material accounts by subinventory code or cost group
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MCA.ORGANIZATION_ID ORGANIZATION_ID
, MCA.SUBINVENTORY_CODE SUBINVENTORY_CODE
, TO_CHAR(MCA.COST_GROUP_ID) COST_GROUP_ID
, MIC.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MCA.MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MCA.MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, MCA.RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, MCA.OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, MCA.OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, MCA.EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, MCA.ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, MCA.BRIDGING_ACCOUNT BRIDGING_ACCOUNT
, MCA.ANALYTICAL_IPV ANALYTICAL_IPV
, MCA.ANALYTICAL_PO_MIRROR ANALYTICAL_PO_MIRROR
, MCA.NON_INVOICED_SO NON_INVOICED_SO
, MCA.NON_INVOICED_REVENUE NON_INVOICED_REVENUE
, MCA.ANALYTICAL_REVENUE_MIRROR ANALYTICAL_REVENUE_MIRROR
, MCA.ANALYTICAL_MOGS ANALYTICAL_MOGS
FROM MTL_CATEGORY_ACCOUNTS MCA
, MTL_CATEGORY_SETS MCS
, MTL_ITEM_CATEGORIES MIC
WHERE MCS.CATEGORY_SET_NAME = 'ACCOUNTING'
AND MCA.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MIC.CATEGORY_ID = MCA.CATEGORY_ID
AND MIC.ORGANIZATION_ID = MCA.ORGANIZATION_ID

Columns

Name
ORGANIZATION_ID
SUBINVENTORY_CODE
COST_GROUP_ID
INVENTORY_ITEM_ID
MATERIAL_ACCOUNT
MATERIAL_OVERHEAD_ACCOUNT
RESOURCE_ACCOUNT
OUTSIDE_PROCESSING_ACCOUNT
OVERHEAD_ACCOUNT
EXPENSE_ACCOUNT
ENCUMBRANCE_ACCOUNT
BRIDGING_ACCOUNT
ANALYTICAL_IPV
ANALYTICAL_PO_MIRROR
NON_INVOICED_SO
NON_INVOICED_REVENUE
ANALYTICAL_REVENUE_MIRROR
ANALYTICAL_MOGS