DBA Data[Home] [Help]

APPS.GMI_LOCT_INV_PVT dependencies on IC_ITEM_CPG

Line 148: from ic_item_cpg

144: and hold date is null. update_ic_loct_inv internally calls insert_ic_loct_inv
145: if there is no existing inventory*/
146: Update ic_lots_cpg
147: Set ic_hold_date = (select p_tran_rec.trans_date + ic_hold_days
148: from ic_item_cpg
149: where item_id = l_loct_inv.item_id
150: )
151: Where item_id = l_loct_inv.item_id and
152: lot_id = l_loct_inv.lot_id and