APPS.GML_INTORD_LOT_STS dependencies on IC_TRAN_PND

Line 421: FROM ic_tran_pnd

417:
418: -- declare cursor to fetch shipped lot and status
419: CURSOR get_omso_lots IS
420: SELECT lot_id,lot_status
421: FROM ic_tran_pnd
422: WHERE doc_type = 'OMSO'
423: AND item_id = p_item_id
424: AND completed_ind = 1
425: AND delete_mark = 0