Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View based on the table AHL_RT_OPER_MATERIALS and two other columns CONCATENATED_SEGMENTS and DESCRIPTION from the view AHL_MTL_ITEMS_OU_V. |
Implementation/DBA Data: | APPS.AHL_RT_OPER_MATERIALS_V |
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
, AMIO.CONCATENATED_SEGMENTS
, AMIO.DESCRIPTION
, AOB.INVENTORY_ORG_ID
, ( SELECT DISTINCT HOU.NAME
FROM MTL_PARAMETERS MP
WHERE AOB.INVENTORY_ORG_ID = MP.MASTER_ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID)
, ( SELECT DISTINCT ORGANIZATION_CODE
FROM MTL_PARAMETERS MP
WHERE MP.MASTER_ORGANIZATION_ID = AOB.INVENTORY_ORG_ID
AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID)
, 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
, AMIO.DESCRIPTION )
, AHL_RM_ROUTE_UTIL.GET_SOURCE_COMPOSITION( AOB.POSITION_PATH_ID
, AOB.ITEM_COMP_DETAIL_ID)
FROM AHL_RT_OPER_MATERIALS AOB
, AHL_ITEM_GROUPS_VL AIG
, MTL_UNITS_OF_MEASURE_VL UOM
, MTL_SYSTEM_ITEMS_KFV AMIO
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HOU
WHERE AIG.ITEM_GROUP_ID (+) = AOB.ITEM_GROUP_ID
AND AMIO.ORGANIZATION_ID(+) = AOB.INVENTORY_ORG_ID
AND AMIO.INVENTORY_ITEM_ID (+) = AOB.INVENTORY_ITEM_ID
AND MP.MASTER_ORGANIZATION_ID(+) = AOB.INVENTORY_ORG_ID
AND HOU.ORGANIZATION_ID (+)= AOB.INVENTORY_ORG_ID
AND UOM.UOM_CODE = AOB.UOM_CODE