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