View: MTL_CATEGORY_ACCOUNTS_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_CATEGORY_ACCOUNTS_V

View Text

SELECT M.ROWID ROW_ID
, M.ORGANIZATION_ID
, M.COST_GROUP_ID
, M.SUBINVENTORY_CODE
, M.CATEGORY_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.MATERIAL_ACCOUNT
, M.MATERIAL_OVERHEAD_ACCOUNT
, M.RESOURCE_ACCOUNT
, M.OUTSIDE_PROCESSING_ACCOUNT
, M.OVERHEAD_ACCOUNT
, M.EXPENSE_ACCOUNT
, M.ENCUMBRANCE_ACCOUNT
, M.BRIDGING_ACCOUNT
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.CATEGORY_SET_ID
, M.ANALYTICAL_IPV
, M.ANALYTICAL_PO_MIRROR
, M.NON_INVOICED_SO
, M.NON_INVOICED_REVENUE
, M.ANALYTICAL_REVENUE_MIRROR
, M.ANALYTICAL_MOGS
, MCK.CONCATENATED_SEGMENTS CATEGORY_CONCAT_SEGS
, MC.DESCRIPTION MDESC
, S.DESCRIPTION SDESC
, CCG.COST_GROUP
, CCG.DESCRIPTION CDESC
, MP.PROJECT_REFERENCE_ENABLED
, M.AVERAGE_COST_VAR_ACCOUNT
FROM MTL_CATEGORY_ACCOUNTS M
, MTL_CATEGORIES_KFV MCK
, MTL_CATEGORIES MC
, MTL_SECONDARY_INVENTORIES S
, CST_COST_GROUPS CCG
, MTL_PARAMETERS MP
WHERE M.COST_GROUP_ID = CCG.COST_GROUP_ID(+)
AND MP.ORGANIZATION_ID = M.ORGANIZATION_ID
AND M.CATEGORY_ID = MCK.CATEGORY_ID
AND M.CATEGORY_ID = MC.CATEGORY_ID
AND S.SECONDARY_INVENTORY_NAME(+) = M.SUBINVENTORY_CODE
AND M.ORGANIZATION_ID = S.ORGANIZATION_ID(+)
AND (S.SUBINVENTORY_TYPE = 1 OR S.SUBINVENTORY_TYPE IS NULL)

Columns