APPS.INV_RCV_COMMON_APIS dependencies on MTL_SYSTEM_ITEMS

Line 365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2

361:
362: IF p_req_header_id IS NOT NULL THEN
363: SELECT 'N'
364: INTO l_lot_ser_flag
365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2
366: WHERE prh.requisition_header_id = p_req_header_id
367: AND prl.requisition_header_id = prh.requisition_header_id
368: AND rsl.requisition_line_id = prl.requisition_line_id
369: AND rsl.item_id = msi1.inventory_item_id

Line 386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2

382: AND ROWNUM = 1;
383: ELSIF p_shipment_header_id IS NOT NULL THEN
384: SELECT 'N'
385: INTO l_lot_ser_flag
386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2
387: WHERE rsh.shipment_header_id = p_shipment_header_id
388: AND rsl.shipment_header_id = rsh.shipment_header_id
389: AND rsl.item_id = msi1.inventory_item_id
390: AND msi1.organization_id = rsl.from_organization_id

Line 2695: FROM mtl_system_items

2691: END IF;
2692:
2693: SELECT NVL(x_default_routing_id, receiving_routing_id)
2694: INTO x_default_routing_id
2695: FROM mtl_system_items
2696: WHERE inventory_item_id = p_item_id
2697: AND organization_id = p_organization_id;
2698: EXCEPTION
2699: WHEN NO_DATA_FOUND THEN

Line 2932: FROM mtl_system_items

2928:
2929: BEGIN
2930: SELECT return_inspection_requirement
2931: INTO x_routing_id
2932: FROM mtl_system_items
2933: WHERE inventory_item_id = p_item_id
2934: AND organization_id = p_organization_id;
2935: EXCEPTION
2936: WHEN OTHERS THEN

Line 3102: FROM mtl_system_items

3098: SELECT NVL(restrict_locators_code, 2)
3099: , NVL(restrict_subinventories_code, 2)
3100: INTO l_restrict_locator_code
3101: , l_restrict_sub_code
3102: FROM mtl_system_items
3103: WHERE inventory_item_id = p_item_id
3104: AND organization_id = p_organization_id;
3105:
3106: IF l_sub <> '@@@' THEN

Line 5263: mtl_system_items

5259:
5260: SELECT lot_status_enabled --Added select for bug3998321
5261: INTO l_status_enabled
5262: FROM
5263: mtl_system_items
5264: WHERE
5265: inventory_item_id=p_inventory_item_id and
5266: organization_id=p_transfer_organization_id;
5267:

Line 5271: mtl_system_items

5267:
5268: SELECT lot_status_enabled --Added select for bug4035918
5269: INTO l_dest_status_enabled
5270: FROM
5271: mtl_system_items
5272: WHERE
5273: inventory_item_id=p_inventory_item_id and
5274: organization_id=p_organization_id;
5275:

Line 6665: FROM mtl_system_items

6661: x_return_status := 'S';
6662:
6663: SELECT serial_number_control_code
6664: INTO x_serial_control
6665: FROM mtl_system_items
6666: WHERE inventory_item_id = p_item_id
6667: AND organization_id = p_from_org_id;
6668: EXCEPTION
6669: WHEN OTHERS THEN

Line 7006: FROM mtl_system_items_kfv

7002: -- Make sure that cross_reference does not exist as a master item.
7003: BEGIN
7004: SELECT inventory_item_id
7005: INTO l_inventory_item_id
7006: FROM mtl_system_items_kfv
7007: WHERE concatenated_segments = p_cross_reference;
7008:
7009: l_progress := '10';
7010:

Line 7135: FROM mtl_system_items

7131: x_return_status := fnd_api.g_ret_sts_success;
7132:
7133: SELECT lot_control_code
7134: INTO x_lot_control
7135: FROM mtl_system_items
7136: WHERE inventory_item_id = p_item_id
7137: AND organization_id = p_from_org_id;
7138: EXCEPTION
7139: WHEN fnd_api.g_exc_error THEN