View: AHL_NR_PROFILE_DETAILS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:
Implementation/DBA Data:	APPS.AHL_NR_PROFILE_DETAILS_V

View Text

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