APPS.GMD_SPREAD_FETCH_PKG dependencies on MTL_LOT_NUMBERS

Line 50: FROM lm_sprd_dtl a, mtl_system_items_b b, mtl_lot_numbers c,

46: CURSOR Cur_get_spread IS
47: SELECT a.*,b.description,b.lot_control_code,b.secondary_default_ind,
48: b.grade_control_flag,b.location_control_code,b.tracking_quantity_ind,c.expiration_date expiry_date,
49: b.primary_uom_code PRIMARY, c.lot_number lot, d.batchstep_no
50: FROM lm_sprd_dtl a, mtl_system_items_b b, mtl_lot_numbers c,
51: gme_batch_steps d, gme_batch_step_items e
52: WHERE a.inventory_item_id = b.inventory_item_id
53: AND a.organization_id = b.organization_id
54: AND a.inventory_item_id = c.inventory_item_id (+)

Line 173: mtl_lot_numbers c

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
177: AND b.organization_id = c.organization_id

Line 187: FROM mtl_system_items b,mtl_lot_numbers c

183: CURSOR Cur_get_controls (V_inventory_item_id NUMBER,V_lot_number VARCHAR2,V_organization_id NUMBER) IS
184: SELECT b.tracking_quantity_ind,b.lot_control_code,
185: b.grade_control_flag,b.location_control_code,
186: b.default_grade,b.secondary_default_ind,c.expiration_date,c.organization_id
187: FROM mtl_system_items b,mtl_lot_numbers c
188: WHERE b.inventory_item_id = c.inventory_item_id
189: AND b.organization_id = c.organization_id
190: AND b.inventory_item_id = V_inventory_item_id
191: AND b.organization_id = V_organization_id

Line 509: FROM gmd_material_details_gtmp a, mtl_lot_numbers b, (select inventory_item_id,lot_number, lot_organization_id

505: ORDER BY a.line_type, a.line_no;
506:
507: CURSOR Cur_get_materials IS
508: SELECT a.*, b.lot_number lot,b.expiration_date expire, b.inventory_item_id itemid
509: FROM gmd_material_details_gtmp a, mtl_lot_numbers b, (select inventory_item_id,lot_number, lot_organization_id
510: from gmd_technical_data_vl group by inventory_item_id,lot_number,lot_organization_id) c
511: WHERE a.entity_id = V_formula_id
512: AND a.inventory_item_id = b.inventory_item_id
513: AND a.inventory_item_id = c.inventory_item_id

Line 1961: FROM gmd_material_details_gtmp a, MTL_LOT_NUMBERS b,

1957:
1958:
1959: CURSOR Cur_get_materials IS
1960: SELECT a.*,b.PARENT_LOT_NUMBER lot, b.LOT_NUMBER sublot, NULL item_lotid, b.EXPIRATION_DATE expire, b.inventory_item_id itemid
1961: FROM gmd_material_details_gtmp a, MTL_LOT_NUMBERS b,
1962: (select inventory_item_id,lot_NUMBER from gmd_technical_data_vl group by inventory_item_id,lot_NUMBER) c
1963: WHERE a.entity_id = V_formula_id
1964: AND a.inventory_item_id = b.inventory_item_id
1965: AND a.inventory_item_id = c.inventory_item_id