VIEW: APPS.AHL_INV_SERVICE_ITEM_RELS_V

Source

View Text - Preformatted

SELECT ahl.inv_service_item_rel_id, ahl.object_version_number, ahl.creation_date, ahl.created_by, ahl.last_update_date, ahl.last_updated_by, ahl.last_update_login, ahl.inv_item_id, mtl1.concatenated_segments, mtl1.description, mtl1.primary_uom_code, ahl.inv_org_id, org.organization_code, hou.name organization_name, org.operating_unit, ahl.service_item_id, mtl2.concatenated_segments, mtl2.description, mtl2.primary_uom_code, ahl.active_start_date, ahl.active_end_date, ahl.RANK, ahl.attribute_category, ahl.attribute1, ahl.attribute2, ahl.attribute3, ahl.attribute4, ahl.attribute5, ahl.attribute6, ahl.attribute7, ahl.attribute8, ahl.attribute9, ahl.attribute10, ahl.attribute11, ahl.attribute12, ahl.attribute13, ahl.attribute14, ahl.attribute15 FROM ahl_inv_service_item_rels ahl, mtl_system_items_kfv mtl1, inv_organization_info_v org, hr_all_organization_units hou, mtl_system_items_kfv mtl2 WHERE ahl.inv_item_id = mtl1.inventory_item_id AND ahl.inv_org_id = mtl1.organization_id AND ahl.service_item_id = mtl2.inventory_item_id AND ahl.inv_org_id = mtl2.organization_id AND ahl.inv_org_id = org.organization_id and ahl.inv_org_id = hou.organization_id AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()

View Text - HTML Formatted

SELECT AHL.INV_SERVICE_ITEM_REL_ID
, AHL.OBJECT_VERSION_NUMBER
, AHL.CREATION_DATE
, AHL.CREATED_BY
, AHL.LAST_UPDATE_DATE
, AHL.LAST_UPDATED_BY
, AHL.LAST_UPDATE_LOGIN
, AHL.INV_ITEM_ID
, MTL1.CONCATENATED_SEGMENTS
, MTL1.DESCRIPTION
, MTL1.PRIMARY_UOM_CODE
, AHL.INV_ORG_ID
, ORG.ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, ORG.OPERATING_UNIT
, AHL.SERVICE_ITEM_ID
, MTL2.CONCATENATED_SEGMENTS
, MTL2.DESCRIPTION
, MTL2.PRIMARY_UOM_CODE
, AHL.ACTIVE_START_DATE
, AHL.ACTIVE_END_DATE
, AHL.RANK
, AHL.ATTRIBUTE_CATEGORY
, AHL.ATTRIBUTE1
, AHL.ATTRIBUTE2
, AHL.ATTRIBUTE3
, AHL.ATTRIBUTE4
, AHL.ATTRIBUTE5
, AHL.ATTRIBUTE6
, AHL.ATTRIBUTE7
, AHL.ATTRIBUTE8
, AHL.ATTRIBUTE9
, AHL.ATTRIBUTE10
, AHL.ATTRIBUTE11
, AHL.ATTRIBUTE12
, AHL.ATTRIBUTE13
, AHL.ATTRIBUTE14
, AHL.ATTRIBUTE15
FROM AHL_INV_SERVICE_ITEM_RELS AHL
, MTL_SYSTEM_ITEMS_KFV MTL1
, INV_ORGANIZATION_INFO_V ORG
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS_KFV MTL2
WHERE AHL.INV_ITEM_ID = MTL1.INVENTORY_ITEM_ID
AND AHL.INV_ORG_ID = MTL1.ORGANIZATION_ID
AND AHL.SERVICE_ITEM_ID = MTL2.INVENTORY_ITEM_ID
AND AHL.INV_ORG_ID = MTL2.ORGANIZATION_ID
AND AHL.INV_ORG_ID = ORG.ORGANIZATION_ID
AND AHL.INV_ORG_ID = HOU.ORGANIZATION_ID
AND NVL(ORG.OPERATING_UNIT
, MO_GLOBAL.GET_CURRENT_ORG_ID()) = MO_GLOBAL.GET_CURRENT_ORG_ID()