[Home] [Help]
321: /* nsinghi MIN-MAX INVCONV end */
322: pick_components_flag pick_components
323: FROM mtl_categories b,
324: mtl_item_categories a,
325: mtl_system_items_vl c,
326: mtl_parameters p
327: WHERE b.category_id = a.category_id
328: AND b.structure_id = :mcat_struct_id
329: AND c.inventory_item_flag = ''Y''
403: /* nsinghi MIN-MAX INVCONV end */
404: pick_components_flag
405: FROM mtl_categories b,
406: mtl_item_categories a,
407: mtl_system_items_vl c,
408: mtl_parameters p,
409: mtl_secondary_inventories m,
410: mtl_item_sub_inventories s
411: WHERE b.category_id = a.category_id
469: /* nsinghi MIN-MAX INVCONV end */
470: pick_components_flag
471: FROM mtl_categories b,
472: mtl_item_categories a,
473: mtl_system_items_vl c,
474: mtl_parameters p,
475: per_all_people_f v
476: WHERE b.category_id = a.category_id
477: AND b.structure_id = :mcat_struct_id
560: /* nsinghi MIN-MAX INVCONV end */
561: pick_components_flag
562: FROM mtl_categories b,
563: mtl_item_categories a,
564: mtl_system_items_vl c,
565: mtl_parameters p,
566: mtl_secondary_inventories m,
567: mtl_item_sub_inventories s,
568: per_all_people_f v
1321: primary uom code */
1322:
1323: SELECT uom_code
1324: INTO l_puom
1325: FROM mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
1326: WHERE msiv.inventory_item_id = p_item_id
1327: AND msiv.organization_id = p_org_id
1328: AND muom.unit_of_measure = msiv.primary_unit_of_measure;
1329:
3980: l_check_uom := 0;
3981:
3982: select uom_code
3983: into l_unit_of_issue
3984: from mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
3985: where msiv.inventory_item_id = p_item_id
3986: and msiv.organization_id = p_organization_id
3987: and muom.unit_of_measure = NVL(msiv.unit_of_issue,msiv.primary_unit_of_measure);
3988: