VIEW: APPS.AHL_PLANNING_FACTORS_V

Source

View Text - Preformatted

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
   

View Text - HTML Formatted

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