357: ** Fetch receiving transaction information: lot number, item revision
358: ** subinventory, receiving quantity and transactable flag.
359: */
360: /* Bug2197831:Added a decode statement to check the revision of
361: item-REVISION_QTY_CONTROL_CODE in MTL_SYSTEM_ITEMS and pass the
362: value of the revision or NULL accordingly.
363: */
364: BEGIN
365:
392: l_transactable,
393: l_sn_control_code,
394: l_as_alpha_prefix,
395: l_transfer_lpn_id -- bug 3544019
396: FROM mtl_system_items mi,
397: mtl_secondary_inventories msinv,
398: rcv_shipment_lines rs,
399: rcv_transactions rt
400: WHERE rt.transaction_id = l_transaction_id
556:
557: BEGIN
558: SELECT NVL(reservable_type,2)
559: INTO l_item_reservable
560: FROM mtl_system_items
561: WHERE inventory_item_id = l_line_rec.inventory_item_id
562: AND organization_id = l_line_rec.ship_from_org_id;
563:
564: IF l_debug_level > 0 THEN
1078:
1079: BEGIN
1080: SELECT primary_uom_code
1081: INTO l_primary_uom
1082: FROM mtl_system_items
1083: WHERE inventory_item_id = p_line_rec.inventory_item_id
1084: AND organization_id = p_line_rec.ship_from_org_id;
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1937: l_exist NUMBER := 0;
1938:
1939: Cursor get_opm_item_no IS
1940: Select distinct segment1
1941: From mtl_system_items
1942: Where inventory_item_id = p_inventory_item_id
1943: and organization_id = p_warehouse_id;
1944:
1945: Cursor get_opm_item_id IS