DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on GME_PENDING_PRODUCT_LOTS

Line 172: FROM gme_pending_product_lots a, gmd_material_details_gtmp b,

168: SELECT a.*, c.expiration_date, b.inventory_item_id,
169: b.detail_uom, b.primary_uom, b.secondary_uom,
170: b.tracking_quantity_ind,b.lot_control_code,b.secondary_default_ind,
171: b.grade_control_flag,b.location_control_code, b.organization_id,b.locator_id
172: FROM gme_pending_product_lots a, gmd_material_details_gtmp b,
173: mtl_lot_numbers c
174: WHERE a.material_detail_id = b.material_detail_id
175: AND a.material_detail_id = V_matl_detl_id
176: AND a.batch_id = V_batch_id