DBA Data[Home] [Help]

APPS.RCV_RECEIPTS_QUERY_SV dependencies on MTL_SYSTEM_ITEMS

Line 325: FROM mtl_system_items msi

321: ** value.
322: */
323: SELECT msi.primary_unit_of_measure
324: INTO X_primary_uom
325: FROM mtl_system_items msi
326: WHERE inventory_item_id = x_item_id
327: AND organization_id = x_org_id;
328:
329:

Line 629: FROM mtl_system_items

625: BEGIN
626:
627: SELECT NVL(receiving_routing_id,0)
628: INTO x_routing_id
629: FROM mtl_system_items
630: WHERE inventory_item_id = x_item_id
631: AND organization_id = x_org_id;
632:
633: EXCEPTION