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 2553: FROM mtl_system_items

2549: END IF;
2550:
2551: SELECT NVL(x_default_routing_id, receiving_routing_id)
2552: INTO x_default_routing_id
2553: FROM mtl_system_items
2554: WHERE inventory_item_id = p_item_id
2555: AND organization_id = p_organization_id;
2556: EXCEPTION
2557: WHEN NO_DATA_FOUND THEN

Line 2787: FROM mtl_system_items

2783:
2784: BEGIN
2785: SELECT return_inspection_requirement
2786: INTO x_routing_id
2787: FROM mtl_system_items
2788: WHERE inventory_item_id = p_item_id
2789: AND organization_id = p_organization_id;
2790: EXCEPTION
2791: WHEN OTHERS THEN

Line 2924: FROM mtl_system_items

2920: SELECT NVL(restrict_locators_code, 2)
2921: , NVL(restrict_subinventories_code, 2)
2922: INTO l_restrict_locator_code
2923: , l_restrict_sub_code
2924: FROM mtl_system_items
2925: WHERE inventory_item_id = p_item_id
2926: AND organization_id = p_organization_id;
2927:
2928: IF l_sub <> '@@@' THEN

Line 4738: mtl_system_items

4734:
4735: SELECT lot_status_enabled --Added select for bug3998321
4736: INTO l_status_enabled
4737: FROM
4738: mtl_system_items
4739: WHERE
4740: inventory_item_id=p_inventory_item_id and
4741: organization_id=p_transfer_organization_id;
4742:

Line 4746: mtl_system_items

4742:
4743: SELECT lot_status_enabled --Added select for bug4035918
4744: INTO l_dest_status_enabled
4745: FROM
4746: mtl_system_items
4747: WHERE
4748: inventory_item_id=p_inventory_item_id and
4749: organization_id=p_organization_id;
4750:

Line 6133: FROM mtl_system_items

6129: x_return_status := 'S';
6130:
6131: SELECT serial_number_control_code
6132: INTO x_serial_control
6133: FROM mtl_system_items
6134: WHERE inventory_item_id = p_item_id
6135: AND organization_id = p_from_org_id;
6136: EXCEPTION
6137: WHEN OTHERS THEN

Line 6474: FROM mtl_system_items_kfv

6470: -- Make sure that cross_reference does not exist as a master item.
6471: BEGIN
6472: SELECT inventory_item_id
6473: INTO l_inventory_item_id
6474: FROM mtl_system_items_kfv
6475: WHERE concatenated_segments = p_cross_reference;
6476:
6477: l_progress := '10';
6478:

Line 6603: FROM mtl_system_items

6599: x_return_status := fnd_api.g_ret_sts_success;
6600:
6601: SELECT lot_control_code
6602: INTO x_lot_control
6603: FROM mtl_system_items
6604: WHERE inventory_item_id = p_item_id
6605: AND organization_id = p_from_org_id;
6606: EXCEPTION
6607: WHEN fnd_api.g_exc_error THEN