DBA Data[Home] [Help]

APPS.GMI_INVENTORY_CLOSE_CONC dependencies on IC_LOCT_INV

Line 421: from ic_loct_inv v, ic_item_mst_b m

417: SELECT v.item_id ,v.lot_id ,
418: whse_code ,location ,ROUND(loct_onhand,9) onhand,
419: ROUND(loct_onhand2,9) onhand2,
420: v.lot_status,v.qchold_res_code
421: from ic_loct_inv v, ic_item_mst_b m
422: WHERE whse_code = pwhse_code
423: AND noninv_ind = 0
424: AND v.item_id = m.item_id
425: AND v.delete_mark = 0