[Home] [Help]
2233: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
2234: SELECT d.*, i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
2235: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
2236: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
2237: FROM gme_material_details d, mtl_system_items_b i
2238: WHERE d.material_detail_id = v_material_detail_id
2239: AND i.organization_id = d.organization_id
2240: AND i.inventory_item_id = d.inventory_item_id;
2241: CURSOR Cur_lot_mst(v_lot_id NUMBER) IS
3290: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
3291: SELECT i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
3292: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
3293: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
3294: FROM mtl_system_items_b i
3295: WHERE i.organization_id = v_organization_id
3296: AND i.inventory_item_id = v_inventory_item_id;
3297: CURSOR Cur_new_loc(v_organization_id NUMBER, v_subinventory VARCHAR2, v_location VARCHAR2) IS
3298: SELECT m.inventory_location_id locator_id
3970: WHERE m.old_batch_id = l.batch_id
3971: AND NVL(attribute27, 'A') <> 'M';
3972: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
3973: SELECT i.segment1, i.lot_control_code
3974: FROM mtl_system_items_b i
3975: WHERE i.organization_id = v_organization_id
3976: AND i.inventory_item_id = v_inventory_item_id;
3977: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
3978: SELECT d.*