Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AHL_RESOURCE_MAPPINGS_V |
SELECT R.RESOURCE_MAPPING_ID
, R.OBJECT_VERSION_NUMBER
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.ASO_RESOURCE_ID
, R.BOM_RESOURCE_ID
, R.BOM_ORG_ID
, BOM.RESOURCE_CODE
, HOU.NAME
, BOM.DESCRIPTION
, BOM.DISABLE_DATE
, BOM.RESOURCE_TYPE
, MFG.MEANING
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
FROM AHL_RESOURCE_MAPPINGS R
, BOM_RESOURCES BOM
, HR_ORGANIZATION_UNITS HOU
, MFG_LOOKUPS MFG
WHERE R.BOM_RESOURCE_ID = BOM.RESOURCE_ID
AND R.BOM_ORG_ID = BOM.ORGANIZATION_ID
AND R.BOM_ORG_ID = HOU.ORGANIZATION_ID
AND MFG.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE'
AND MFG.LOOKUP_CODE (+) = BOM.RESOURCE_TYPE