APPS.GMI_INVENTORY_CLOSE_CONC dependencies on IC_TRAN_PND

Line 460: FROM ic_tran_pnd p, ic_item_mst_b m

456: SELECT p.item_id, lot_id, whse_code,
457: location, doc_type, line_type,
458: reason_code, trans_date, trans_id,
459: trans_qty, trans_qty2
460: FROM ic_tran_pnd p, ic_item_mst_b m
461: WHERE whse_code = uwhse_code
462: AND trans_date >= pprd_start_date
463: AND p.creation_date <= l_log_end_date
464: AND trans_qty <> 0