APPS.INV_LOC_WMS_UTILS dependencies on MTL_SYSTEM_ITEMS

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

611: -- ensure that the input quantity (p_quantity) is always positive regardless whether
612: -- issue or receipt
613: l_quantity :=Abs(p_quantity);
614:
615: -- select necessary data from mtl_system_items and mtl_item_locations
616: select
617: primary_uom_code,
618: weight_uom_code,
619: unit_weight,

Line 628: from mtl_system_items

624: l_item_weight_uom_code,
625: l_item_unit_weight,
626: l_item_volume_uom_code,
627: l_item_unit_volume
628: from mtl_system_items
629: where organization_id = p_organization_id
630: and inventory_item_id = p_inventory_item_id;
631:
632: select

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

1287:
1288: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1289: -- issue or receipt
1290: l_quantity :=Abs(p_quantity);
1291: -- select necessary data from mtl_system_items and mtl_item_locations
1292: select
1293: primary_uom_code,
1294: weight_uom_code,
1295: unit_weight,

Line 1304: from mtl_system_items

1300: l_item_weight_uom_code,
1301: l_item_unit_weight,
1302: l_item_volume_uom_code,
1303: l_item_unit_volume
1304: from mtl_system_items
1305: where organization_id = p_organization_id
1306: and inventory_item_id = p_inventory_item_id;
1307:
1308: select

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

1848:
1849: -- ensure that the input quantity (p_quantity) is always positive regardless whether
1850: -- issue or receipt
1851: l_quantity :=Abs(p_quantity);
1852: -- select necessary data from mtl_system_items and mtl_item_locations
1853: select
1854: primary_uom_code,
1855: weight_uom_code,
1856: unit_weight,

Line 1865: from mtl_system_items

1861: l_item_weight_uom_code,
1862: l_item_unit_weight,
1863: l_item_volume_uom_code,
1864: l_item_unit_volume
1865: from mtl_system_items
1866: where organization_id = p_organization_id
1867: and inventory_item_id = p_inventory_item_id;
1868:
1869: select

Line 2752: from mtl_system_items

2748: , t_item_info(l_inventory_item_id).item_weight_uom_code
2749: , t_item_info(l_inventory_item_id).item_unit_weight
2750: , t_item_info(l_inventory_item_id).item_volume_uom_code
2751: , t_item_info(l_inventory_item_id).item_unit_volume
2752: from mtl_system_items
2753: where organization_id = p_organization_id
2754: and inventory_item_id = l_inventory_item_id;
2755: end if;
2756:

Line 6537: mtl_system_items

6533: ,l_item_unit_weight
6534: ,l_item_volume_uom_code
6535: ,l_item_unit_volume
6536: FROM
6537: mtl_system_items
6538: WHERE
6539: inventory_item_id = p_inventory_item_id and
6540: organization_id = p_organization_id;
6541: