DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1191: from mtl_item_locations_kfv k

1187: else
1188: if p_wms_task_type in (1,4,5) then
1189: begin
1190: select concatenated_segments into v_concatenated_segments
1191: from mtl_item_locations_kfv k
1192: where k.inventory_location_id = p_transfer_to_location_id
1193: and k.organization_id = p_organization_id;
1194: EXCEPTION
1195: WHEN no_data_found THEN

Line 1203: from mtl_item_locations_kfv k

1199: END;
1200: elsif p_wms_task_type = 2 then
1201: begin
1202: select concatenated_segments into v_concatenated_segments
1203: from mtl_item_locations_kfv k
1204: where k.inventory_location_id = p_locator_id
1205: and k.organization_id = p_organization_id;
1206: EXCEPTION
1207: WHEN no_data_found THEN