DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1027: mtl_item_locations_kfv c,

1023: INTO l_organization_id,l_lot_control_code,l_grade_control_flag,l_child_lot_flag,l_lot_status_enabled,l_sample_type,l_source,
1024: l_inventory_item_id,l_parent_lot_number,l_lot_number,l_lpn_id,l_subinventory,l_locator_id,l_locator,l_lpn_id,l_lpn,l_wms_enabled_flag
1025: FROM gmd_samples a,
1026: mtl_system_items_b b,
1027: mtl_item_locations_kfv c,
1028: wms_license_plate_numbers d,
1029: mtl_parameters e
1030: WHERE a.sample_id = l_update_disp_rec.sample_id
1031: AND a.delete_mark = 0

Line 1172: mtl_item_locations_kfv mil,

1168: gmd_event_spec_disp esd ,
1169: gmd_sampling_events gse,
1170: mtl_system_items_b msi,
1171: gmd_specifications_b gsb,
1172: mtl_item_locations_kfv mil,
1173: wms_license_plate_numbers wlpn,
1174: mtl_parameters mp
1175: WHERE csd.composite_spec_disp_id = l_update_disp_rec.composite_spec_disp_id
1176: AND csd.event_spec_disp_id = esd.event_spec_disp_id