APPS.INV_RCV_STD_INSPECT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 631: FROM mtl_system_items

627: l_progress := '120';
628:
629: SELECT lot_control_code, serial_number_control_code
630: INTO l_lot_control_code, l_serial_control_code
631: FROM mtl_system_items
632: WHERE inventory_item_id = p_inventory_item_id
633: AND organization_id = p_organization_id;
634:
635: IF (l_lot_control_code > 1 OR l_serial_control_code > 1)

Line 2970: FROM mtl_system_items

2966: SELECT lot_control_code
2967: , serial_number_control_code
2968: INTO l_lot_control_code
2969: , l_serial_control_code
2970: FROM mtl_system_items
2971: WHERE inventory_item_id = p_inventory_item_id
2972: AND organization_id = p_organization_id;
2973:
2974: IF (l_lot_control_code > 1 OR l_serial_control_code > 1) THEN

Line 3228: FROM mtl_system_items

3224: end if;
3225:
3226: SELECT primary_uom_code
3227: INTO l_primary_uom_code
3228: FROM mtl_system_items
3229: WHERE organization_id = p_organization_id
3230: AND inventory_item_id = p_inventory_item_id
3231: AND serial_number_control_code IN (2, 5, 6);
3232:

Line 3545: from mtl_system_items

3541: -- One time fetch of item's primary uom code
3542: -- Fetching revision control for bug 3134272
3543: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
3544: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
3545: from mtl_system_items
3546: where organization_id = l_organization_id
3547: and inventory_item_id = l_inventory_item_id;
3548:
3549: -- dbms_output.put_line('main_process_po: Fetched item primary uom code');

Line 3960: from mtl_system_items

3956: -- One time fetch of item's primary uom code
3957: -- Fetching revision control for bug 3134272
3958: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
3959: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
3960: from mtl_system_items
3961: where organization_id = l_organization_id
3962: and inventory_item_id = l_inventory_item_id;
3963:
3964: -- dbms_output.put_line('main_process_intransit: Fetched item primary uom code');

Line 4376: from mtl_system_items

4372: -- One time fetch of item's primary uom code
4373: -- Fetching revision control for bug 3134272
4374: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
4375: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
4376: from mtl_system_items
4377: where organization_id = l_organization_id
4378: and inventory_item_id = l_inventory_item_id;
4379:
4380: -- dbms_output.put_line('main_process_rma: Fetched item primary uom code');

Line 4789: from mtl_system_items

4785: -- One time fetch of item's primary uom code
4786: -- Fetching revision control for bug 3134272
4787: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
4788: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
4789: from mtl_system_items
4790: where organization_id = l_organization_id
4791: and inventory_item_id = l_inventory_item_id;
4792:
4793: -- dbms_output.put_line('main_process_receipt: Fetched item primary uom code');

Line 5304: ,mtl_system_items msi

5300: ,rcv_shipment_lines rsl
5301: ,rcv_transactions rt
5302: ,po_line_locations pll
5303: ,po_lines pol
5304: ,mtl_system_items msi
5305: ,mtl_customer_items mci
5306: ,oe_order_lines_all oel
5307: WHERE rt.transaction_id = l_rcv_transaction_id
5308: AND rt.transaction_type <> 'UNORDERED'