Product: | AX - Global Accounting Engine |
---|---|
Description: | material accounts by subinventory code or cost group |
Implementation/DBA Data: | Not implemented in this database |
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