APPS.INV_LOC_WMS_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 648: -- select necessary data from mtl_system_items and mtl_item_locations

644: -- ensure that the input quantity (p_quantity) is always positive regardless whether
645: -- issue or receipt
646: l_quantity :=Abs(p_quantity);
647:
648: -- select necessary data from mtl_system_items and mtl_item_locations
649: select
650: primary_uom_code,
651: weight_uom_code,
652: unit_weight,

Line 661: from mtl_system_items

657: l_item_weight_uom_code,
658: l_item_unit_weight,
659: l_item_volume_uom_code,
660: l_item_unit_volume
661: from mtl_system_items
662: where organization_id = p_organization_id
663: and inventory_item_id = p_inventory_item_id;
664:
665: select

Line 1356: -- select necessary data from mtl_system_items and mtl_item_locations

1352:
1353: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1354: -- issue or receipt
1355: l_quantity :=Abs(p_quantity);
1356: -- select necessary data from mtl_system_items and mtl_item_locations
1357: select
1358: primary_uom_code,
1359: weight_uom_code,
1360: unit_weight,

Line 1369: from mtl_system_items

1365: l_item_weight_uom_code,
1366: l_item_unit_weight,
1367: l_item_volume_uom_code,
1368: l_item_unit_volume
1369: from mtl_system_items
1370: where organization_id = p_organization_id
1371: and inventory_item_id = p_inventory_item_id;
1372:
1373: select

Line 1922: -- select necessary data from mtl_system_items and mtl_item_locations

1918:
1919: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1920: -- issue or receipt
1921: l_quantity :=Abs(p_quantity);
1922: -- select necessary data from mtl_system_items and mtl_item_locations
1923: select
1924: primary_uom_code,
1925: weight_uom_code,
1926: unit_weight,

Line 1935: from mtl_system_items

1931: l_item_weight_uom_code,
1932: l_item_unit_weight,
1933: l_item_volume_uom_code,
1934: l_item_unit_volume
1935: from mtl_system_items
1936: where organization_id = p_organization_id
1937: and inventory_item_id = p_inventory_item_id;
1938:
1939: select

Line 3050: FROM mtl_system_items

3046: ,volume_uom_code
3047: ,unit_volume
3048: INTO t_item_info(t_inventory_item_id(i)).inventory_item_id,t_item_info(t_inventory_item_id(i)).item_primary_uom_code,t_item_info(t_inventory_item_id(i)).item_weight_uom_code,t_item_info(t_inventory_item_id(i)).item_unit_weight,
3049: t_item_info(t_inventory_item_id(i)).item_volume_uom_code,t_item_info(t_inventory_item_id(i)).item_unit_volume
3050: FROM mtl_system_items
3051: WHERE organization_id = p_organization_id
3052: AND inventory_item_id = t_inventory_item_id(i);
3053: END IF;
3054:

Line 6984: mtl_system_items

6980: ,l_item_unit_weight
6981: ,l_item_volume_uom_code
6982: ,l_item_unit_volume
6983: FROM
6984: mtl_system_items
6985: WHERE
6986: inventory_item_id = p_inventory_item_id and
6987: organization_id = p_organization_id;
6988: