VIEW: APPS.AHL_NR_PROFILE_DETAILS_V

Source

View Text - Preformatted

SELECT NPD.NR_PROFILE_DET_ID    ,
       NPD.OBJECT_VERSION_NUMBER,
       NPD.NR_PROFILE_HEADER_ID ,
       RES.RESOURCE_TYPE_ID     ,
       RES.RESOURCE_TYPE        ,
       NPD.CMRO_RESOURCE_ID     ,
       RES.NAME                 ,
       NPD.INVENTORY_ITEM_ID    ,
       MTL.CONCATENATED_SEGMENTS,
       NPD.UOM_CODE             ,
       UOM.UNIT_OF_MEASURE      ,
       NPD.ANALYSIS_QTY         ,
       NPD.REQUIRED_QTY         ,
       NPD.STAGE_TYPE_CODE      ,
       STG.MEANING              ,
       NPD.DEMANTRA_UPDATED_DATE,
       NPD.FLEET_HEADER_ID      ,
       FLT.NAME                 ,
       NPD.OPERATING_ORG_ID     ,
       HOU.NAME                 ,
       NPD.OPERATIONS_TYPE_CODE ,
       OPT.MEANING              ,
       NPD.LAST_UPDATE_DATE     ,
       NPD.LAST_UPDATED_BY      ,
       NPD.CREATION_DATE        ,
       NPD.CREATED_BY           ,
       NPD.LAST_UPDATE_LOGIN    ,
       NPD.EXCLUDED_DATE        ,
       NPD.SECURITY_GROUP_ID
FROM   AHL_NR_PROFILE_DETAILS NPD        ,
       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
  WHERE NPD.CMRO_RESOURCE_ID   = RES.RESOURCE_ID(+)
AND    NPD.INVENTORY_ITEM_ID  = MTL.INVENTORY_ITEM_ID(+)
AND    NPD.UOM_CODE           = UOM.UOM_CODE(+)
AND    STG.LOOKUP_TYPE(+)     = 'AHL_VWP_STAGE_TYPE'
AND    STG.LOOKUP_CODE(+)     = NPD.STAGE_TYPE_CODE
AND    FLT.FLEET_HEADER_ID(+) = NPD.FLEET_HEADER_ID
AND    OPT.LOOKUP_TYPE(+)     = 'AHL_FLT_OPERATIONS_TYPE'
AND    OPT.LOOKUP_CODE(+)     = NPD.OPERATIONS_TYPE_CODE
AND    HOU.ORGANIZATION_ID(+) = NPD.OPERATING_ORG_ID
   

View Text - HTML Formatted

SELECT NPD.NR_PROFILE_DET_ID
, NPD.OBJECT_VERSION_NUMBER
, NPD.NR_PROFILE_HEADER_ID
, RES.RESOURCE_TYPE_ID
, RES.RESOURCE_TYPE
, NPD.CMRO_RESOURCE_ID
, RES.NAME
, NPD.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS
, NPD.UOM_CODE
, UOM.UNIT_OF_MEASURE
, NPD.ANALYSIS_QTY
, NPD.REQUIRED_QTY
, NPD.STAGE_TYPE_CODE
, STG.MEANING
, NPD.DEMANTRA_UPDATED_DATE
, NPD.FLEET_HEADER_ID
, FLT.NAME
, NPD.OPERATING_ORG_ID
, HOU.NAME
, NPD.OPERATIONS_TYPE_CODE
, OPT.MEANING
, NPD.LAST_UPDATE_DATE
, NPD.LAST_UPDATED_BY
, NPD.CREATION_DATE
, NPD.CREATED_BY
, NPD.LAST_UPDATE_LOGIN
, NPD.EXCLUDED_DATE
, NPD.SECURITY_GROUP_ID FROM AHL_NR_PROFILE_DETAILS NPD
, 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
WHERE NPD.CMRO_RESOURCE_ID = RES.RESOURCE_ID(+) AND NPD.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID(+) AND NPD.UOM_CODE = UOM.UOM_CODE(+) AND STG.LOOKUP_TYPE(+) = 'AHL_VWP_STAGE_TYPE' AND STG.LOOKUP_CODE(+) = NPD.STAGE_TYPE_CODE AND FLT.FLEET_HEADER_ID(+) = NPD.FLEET_HEADER_ID AND OPT.LOOKUP_TYPE(+) = 'AHL_FLT_OPERATIONS_TYPE' AND OPT.LOOKUP_CODE(+) = NPD.OPERATIONS_TYPE_CODE AND HOU.ORGANIZATION_ID(+) = NPD.OPERATING_ORG_ID