[Home] [Help]
View: AHL_PLANNING_FACTORS_V
View Text
SELECT RES.RESOURCE_TYPE_ID
,
RES.RESOURCE_TYPE
,
RES.RESOURCE_ID
,
NPR.CMRO_RESOURCE_NAME
,
NPR.INVENTORY_ITEM_ID
,
MTL.CONCATENATED_SEGMENTS
,
NPR.UOM_CODE
,
UOM.UNIT_OF_MEASURE
,
NPR.USAGE
,
NPR.VISIT_STAGE_TYPE_CODE
,
STG.MEANING
,
FLT.FLEET_HEADER_ID
,
NPR.FLEET_NAME
,
NPR.OPERATING_ORG_ID
,
HOU.NAME
,
NPR.OPERATIONS_TYPE_CODE
,
OPT.MEANING
,
NPR.MR_TITLE
,
NPH.NR_PROFILE_HEADER_ID
,
NPR.VISIT_TYPE_CODE
,
NPR.ITEM_RESOURCE_FLAG
,
NPR.SOURCE_APPLICATION
,
NPR.MAINTENANCE_TYPE_CODE
,
MNT.MEANING
,
NPR.SECURITY_GROUP_ID
,
NPR.LAST_UPDATE_DATE
,
NPR.LAST_UPDATED_BY
,
NPR.CREATION_DATE
,
NPR.CREATED_BY
,
NPR.LAST_UPDATE_LOGIN
,
NPR.ATTRIBUTE_CATEGORY
,
NPR.ATTRIBUTE1
,
NPR.ATTRIBUTE2
,
NPR.ATTRIBUTE3
,
NPR.ATTRIBUTE4
,
NPR.ATTRIBUTE5
,
NPR.ATTRIBUTE6
,
NPR.ATTRIBUTE7
,
NPR.ATTRIBUTE8
,
NPR.ATTRIBUTE9
,
NPR.ATTRIBUTE10
,
NPR.ATTRIBUTE11
,
NPR.ATTRIBUTE12
,
NPR.ATTRIBUTE13
,
NPR.ATTRIBUTE14
,
NPR.ATTRIBUTE15
FROM AHL_PLANNING_FACTORS NPR
,
AHL_RESOURCES_V RES
,
(SELECT DISTINCT INVENTORY_ITEM_ID
,
CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV
)
MTL
,
MTL_UNITS_OF_MEASURE_VL UOM
,
HR_ALL_ORGANIZATION_UNITS HOU
,
FND_LOOKUPS OPT
,
FND_LOOKUPS STG
,
AHL_FLEET_HEADERS_VL FLT
,
AHL_NR_PROFILE_HEADERS NPH
,
FND_LOOKUPS MNT
WHERE NPH.MR_TITLE = NPR.MR_TITLE
AND NPR.CMRO_RESOURCE_NAME = RES.NAME(+)
AND NPR.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID(+)
AND NPR.UOM_CODE = UOM.UOM_CODE(+)
AND STG.LOOKUP_TYPE(+) = 'AHL_VWP_STAGE_TYPE'
AND STG.LOOKUP_CODE(+) = NPR.VISIT_STAGE_TYPE_CODE
AND FLT.NAME(+) = NPR.FLEET_NAME
AND OPT.LOOKUP_TYPE(+) = 'AHL_FLT_OPERATIONS_TYPE'
AND OPT.LOOKUP_CODE(+) = NPR.OPERATIONS_TYPE_CODE
AND MNT.LOOKUP_TYPE(+) = 'AHL_MAINTENANCE_SOURCE_TYPE'
AND MNT.LOOKUP_CODE(+) = NPR.MAINTENANCE_TYPE_CODE
AND HOU.ORGANIZATION_ID(+) = NPR.OPERATING_ORG_ID