VIEW: APPS.MTL_CATEGORY_ACCOUNTS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)