[Home] [Help]
1015: AND delete_mark = 0;
1016:
1017: CURSOR locid_whse(p_whse_code VARCHAR2) IS
1018: SELECT inventory_location_id
1019: FROM ic_loct_mst
1020: WHERE whse_code = p_whse_code
1021: AND inventory_location_id is not null
1022: AND delete_mark = 0
1023: ORDER BY inventory_location_id;