VIEW: APPS.AHL_RT_OPER_MATERIALS_V

Source

View Text - Preformatted

SELECT DISTINCT aob.rt_oper_material_id, aob.object_version_number, aob.last_update_date, aob.last_updated_by, aob.creation_date, aob.created_by, aob.last_update_login, aob.object_id, aob.item_comp_detail_id, aob.position_path_id, ahl_rm_route_util.get_position_meaning(aob.position_path_id, aob.item_comp_detail_id), aob.item_group_id, aig.name, aig.description, aob.inventory_item_id, mtl_org.concatenated_segments, mtl_org.description, aob.inventory_org_id, mtl_org.organization_name, mtl_org.organization_code, aob.association_type_code, aob.uom_code, uom.unit_of_measure, aob.quantity, aob.duration, aob.revision_number, aob.time_span, aob.attribute_category, aob.attribute1, aob.attribute2, aob.attribute3, aob.attribute4, aob.attribute5, aob.attribute6, aob.attribute7, aob.attribute8, aob.attribute9, aob.attribute10, aob.attribute11, aob.attribute12, aob.attribute13, aob.attribute14, aob.attribute15, aob.exclude_flag, aob.rework_percent, aob.replace_percent, NVL(aig.description, mtl_org.description), ahl_rm_route_util.get_source_composition(aob.position_path_id, aob.item_comp_detail_id), AOB.IN_SERVICE FROM ahl_rt_oper_materials aob, ahl_item_groups_vl aig, mtl_units_of_measure_vl uom, ( SELECT mtl.concatenated_segments, mtl.description, mtl.inventory_item_id, mtl.organization_id, hr_tl.name organization_name, mp.organization_code FROM mtl_system_items_kfv mtl, hr_all_organization_units_tl hr_tl, mtl_parameters mp WHERE mtl.organization_id = mp.organization_id AND mp.organization_id = hr_tl.organization_id AND hr_tl.LANGUAGE = USERENV('LANG') ) mtl_org WHERE aig.item_group_id (+) = aob.item_group_id AND mtl_org.organization_id (+) = aob.inventory_org_id AND mtl_org.inventory_item_id (+) = aob.inventory_item_id AND aob.uom_code = uom.uom_code

View Text - HTML Formatted

SELECT DISTINCT AOB.RT_OPER_MATERIAL_ID
, AOB.OBJECT_VERSION_NUMBER
, AOB.LAST_UPDATE_DATE
, AOB.LAST_UPDATED_BY
, AOB.CREATION_DATE
, AOB.CREATED_BY
, AOB.LAST_UPDATE_LOGIN
, AOB.OBJECT_ID
, AOB.ITEM_COMP_DETAIL_ID
, AOB.POSITION_PATH_ID
, AHL_RM_ROUTE_UTIL.GET_POSITION_MEANING(AOB.POSITION_PATH_ID
, AOB.ITEM_COMP_DETAIL_ID)
, AOB.ITEM_GROUP_ID
, AIG.NAME
, AIG.DESCRIPTION
, AOB.INVENTORY_ITEM_ID
, MTL_ORG.CONCATENATED_SEGMENTS
, MTL_ORG.DESCRIPTION
, AOB.INVENTORY_ORG_ID
, MTL_ORG.ORGANIZATION_NAME
, MTL_ORG.ORGANIZATION_CODE
, AOB.ASSOCIATION_TYPE_CODE
, AOB.UOM_CODE
, UOM.UNIT_OF_MEASURE
, AOB.QUANTITY
, AOB.DURATION
, AOB.REVISION_NUMBER
, AOB.TIME_SPAN
, AOB.ATTRIBUTE_CATEGORY
, AOB.ATTRIBUTE1
, AOB.ATTRIBUTE2
, AOB.ATTRIBUTE3
, AOB.ATTRIBUTE4
, AOB.ATTRIBUTE5
, AOB.ATTRIBUTE6
, AOB.ATTRIBUTE7
, AOB.ATTRIBUTE8
, AOB.ATTRIBUTE9
, AOB.ATTRIBUTE10
, AOB.ATTRIBUTE11
, AOB.ATTRIBUTE12
, AOB.ATTRIBUTE13
, AOB.ATTRIBUTE14
, AOB.ATTRIBUTE15
, AOB.EXCLUDE_FLAG
, AOB.REWORK_PERCENT
, AOB.REPLACE_PERCENT
, NVL(AIG.DESCRIPTION
, MTL_ORG.DESCRIPTION)
, AHL_RM_ROUTE_UTIL.GET_SOURCE_COMPOSITION(AOB.POSITION_PATH_ID
, AOB.ITEM_COMP_DETAIL_ID)
, AOB.IN_SERVICE
FROM AHL_RT_OPER_MATERIALS AOB
, AHL_ITEM_GROUPS_VL AIG
, MTL_UNITS_OF_MEASURE_VL UOM
, ( SELECT MTL.CONCATENATED_SEGMENTS
, MTL.DESCRIPTION
, MTL.INVENTORY_ITEM_ID
, MTL.ORGANIZATION_ID
, HR_TL.NAME ORGANIZATION_NAME
, MP.ORGANIZATION_CODE
FROM MTL_SYSTEM_ITEMS_KFV MTL
, HR_ALL_ORGANIZATION_UNITS_TL HR_TL
, MTL_PARAMETERS MP
WHERE MTL.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = HR_TL.ORGANIZATION_ID
AND HR_TL.LANGUAGE = USERENV('LANG') ) MTL_ORG
WHERE AIG.ITEM_GROUP_ID (+) = AOB.ITEM_GROUP_ID
AND MTL_ORG.ORGANIZATION_ID (+) = AOB.INVENTORY_ORG_ID
AND MTL_ORG.INVENTORY_ITEM_ID (+) = AOB.INVENTORY_ITEM_ID
AND AOB.UOM_CODE = UOM.UOM_CODE