DBA Data[Home] [Help]

APPS.RCV_RECEIPTS_QUERY_SV dependencies on MTL_SYSTEM_ITEMS

Line 304: FROM mtl_system_items msi

300: ** value.
301: */
302: SELECT msi.primary_unit_of_measure
303: INTO X_primary_uom
304: FROM mtl_system_items msi
305: WHERE inventory_item_id = x_item_id
306: AND organization_id = x_org_id;
307:
308:

Line 608: FROM mtl_system_items

604: BEGIN
605:
606: SELECT NVL(receiving_routing_id,0)
607: INTO x_routing_id
608: FROM mtl_system_items
609: WHERE inventory_item_id = x_item_id
610: AND organization_id = x_org_id;
611:
612: EXCEPTION