DBA Data[Home] [Help]

APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on MTL_UOM_CONVERSIONS

Line 702: mtl_uom_conversions muc,

698: wor.assigned_units
699: from wip_discrete_jobs wdj,
700: wip_operations wo,
701: wip_operation_resources wor,
702: mtl_uom_conversions muc,
703: bom_department_resources bdr
704: where wdj.wip_entity_id = p_wipEntityID
705: and wdj.organization_id = p_orgID
706: and wdj.wip_entity_id = wo.wip_entity_id

Line 760: mtl_uom_conversions muc,

756: wcor.assigned_units
757: from wip_discrete_jobs wdj,
758: wsm_copy_operations wco,
759: wsm_copy_op_resources wcor,
760: mtl_uom_conversions muc,
761: bom_department_resources bdr
762: where wdj.wip_entity_id = p_wipEntityID
763: and wdj.organization_id = p_orgID
764: and wdj.wip_entity_id = wco.wip_entity_id

Line 860: from mtl_uom_conversions

856: l_stat_num := 20;
857: l_hrUOM := fnd_profile.value('BOM:HOUR_UOM_CODE');
858: select conversion_rate, uom_class
859: into l_hrVal, l_uomClass
860: from mtl_uom_conversions
861: where uom_code = l_hrUOM
862: and nvl(disable_date, sysdate + 1) > sysdate
863: and inventory_item_id = 0;
864: