DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 2184: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A

2180: BOM.DESCRIPTION resource_name,
2181: MFG.MEANING resource_type_name,
2182: WOR.ASSIGNED_UNITS quantity,
2183: DECODE(nvl(WOR.ASSIGNED_UNITS,0), 0, 0, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) duration ,
2184: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A
2185: WHERE A.UOM_CODE=BOM.UNIT_OF_MEASURE) uom_name,
2186: WOR.RESOURCE_ID,
2187: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
2188: where AWO.workorder_id = wo.workorder_id

Line 7971: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A

7967: BOM.DESCRIPTION resource_name,
7968: MFG.MEANING resource_type_name,
7969: WOR.ASSIGNED_UNITS quantity,
7970: DECODE(nvl(WOR.ASSIGNED_UNITS,0), 0, 0, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) duration ,
7971: (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A
7972: WHERE A.UOM_CODE=BOM.UNIT_OF_MEASURE) uom_name,
7973: WOR.RESOURCE_ID,
7974: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
7975: where AWO.workorder_id = wo.workorder_id