[Home] [Help]
2546: AND rowid BETWEEN p_start_rowid AND p_end_rowid
2547: AND (migrated_ind = 1 OR organization_id IS NOT NULL);
2548:
2549: -- 13685161
2550: CURSOR get_lot (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no ic_lots_mst.lot_no%TYPE ) IS
2551: SELECT lot_no, sublot_no
2552: FROM ic_lots_mst
2553: WHERE item_id = v_item_id
2554: and lot_no = v_lot_no
2548:
2549: -- 13685161
2550: CURSOR get_lot (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no ic_lots_mst.lot_no%TYPE ) IS
2551: SELECT lot_no, sublot_no
2552: FROM ic_lots_mst
2553: WHERE item_id = v_item_id
2554: and lot_no = v_lot_no
2555: ORDER BY sublot_no desc;
2556:
2556:
2557:
2558: -- 13826138
2559: CURSOR get_parent_lot_number_mig (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no
2560: ic_lots_mst.lot_no%TYPE ) IS
2561: SELECT parent_lot_number
2562: FROM ic_lots_mst_mig
2563: WHERE migrated_ind = 1
2564: and item_id = v_item_id
2558: -- 13826138
2559: CURSOR get_parent_lot_number_mig (v_item_id ic_item_mst.item_id%TYPE ,v_lot_no
2560: ic_lots_mst.lot_no%TYPE ) IS
2561: SELECT parent_lot_number
2562: FROM ic_lots_mst_mig
2563: WHERE migrated_ind = 1
2564: and item_id = v_item_id
2565: and parent_lot_number = v_lot_no;
2566:
2961: Get_ODM_LOT API has a parameter Parent_only. For sublot control items call the API with parent only when sublot is not present on sample.
2962:
2963: If this API returns null for parent lot then
2964:
2965: 1Query ic_lots_mst with lot_no and item_id for lot num and sublot num
2966: Check for null sublot first , take this case first pref then sublot - make sure get nul once first
2967:
2968: ( order by lot_id )
2969:
4637: l_locator_id := NULL;
4638: END IF; -- orgn code is null.
4639:
4640: /*=================================
4641: Get Item Id from ic_lots_mst
4642: for use in Lot creation.
4643: =================================*/
4644:
4645: