APPS.RCV_CORE_S dependencies on MTL_SYSTEM_ITEMS

Line 154: FROM mtl_system_items msi

150: AND secondary_inventory_name = dest_subinv
151: AND ( (x_item_id IS NULL)
152: OR ( x_item_id IS NOT NULL
153: AND EXISTS(SELECT 'valid subinventory'
154: FROM mtl_system_items msi
155: WHERE msi.organization_id = x_org_id
156: AND msi.inventory_item_id = x_item_id
157: AND ( msi.restrict_subinventories_code = 2
158: OR ( msi.restrict_subinventories_code = 1

Line 297: -- 2) MTL_SYSTEM_ITEMS (...from the Item Master definition)

293: -- (Overloaded procedure)
294: -- Retrieves default Receiving Controls according to the following hierarchy:
295: --
296: -- 1) PO_LINE_LOCATIONS_ALL (...from the PO Shipment)
297: -- 2) MTL_SYSTEM_ITEMS (...from the Item Master definition)
298: -- 3) PO_VENDORS (...from the Supplier defaults)
299: -- 4) RCV_PARAMETERS (...from the Receiving Controls Setup)
300: --
301: -- For each Receiving Control not gotten at the first level, we will try to

Line 456: FROM mtl_system_items

452: x_qty_rcv_exception_code,
453: x_days_early_receipt_allowed,
454: x_days_late_receipt_allowed,
455: x_receipt_days_exception_code
456: FROM mtl_system_items
457: WHERE inventory_item_id = p_item_id
458: AND NVL(organization_id, -99) = NVL(p_org_id, -99);
459: EXCEPTION
460: WHEN NO_DATA_FOUND THEN

Line 1270: 'MTL_SYSTEM_ITEMS',

1266: END IF;
1267:
1268: x_progress := 70;
1269: x_ret_note_cnt := note_info('ITMIT',
1270: 'MTL_SYSTEM_ITEMS',
1271: 'INVENTORY_ITEM_ID',
1272: x_item_id
1273: );
1274: RETURN(x_ret_note_cnt);