APPS.GMI_PICK_RELEASE_UTIL dependencies on IC_ITEM_MST

Line 400: FROM ic_item_mst

396: AND doc_type = 'OMSO';
397:
398: CURSOR get_item_ctl (p_item_id IN NUMBER) IS
399: SELECT lot_ctl, loct_ctl, noninv_ind
400: FROM ic_item_mst
401: WHERE item_id = p_item_id;
402:
403: CURSOR get_whse_ctl (p_whse_code IN VARCHAR2) IS
404: SELECT loct_ctl

Line 644: FROM ic_item_mst

640:
641:
642: CURSOR get_item_ctl (p_item_id IN NUMBER) IS
643: SELECT lot_ctl, loct_ctl, noninv_ind
644: FROM ic_item_mst
645: WHERE item_id = p_item_id;
646:
647: CURSOR get_whse_ctl (p_whse_code IN VARCHAR2) IS
648: SELECT loct_ctl